• Home »
• Data Warehousing »

Question.1 What are the different uses of a repository manager? Answer: Repository manager used to create repository which contains metadata the informatica uses to transform data to from source to target. And also it use to create informatica user’s and folders and copy, backup and restore tie repository . Question.2..

Question.1   What is Meta Data Repository? Answer:   Meta Data is a data about the data. It also contains Query statistics ETL statistics Business subject area Source Information Target Information Source to Target mapping  Information. Question.2  What is Data Stage Engine? Answer:   It is a JAVA engine running at the background…

Question.1  What are the components of Informatica? And what is the purpose of each? Answer:   Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the trig jered..

Question.1   What is Microstrategy Desktop? Answer:   Microstrategy Desktop  is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities. Question.2   What does Microstrategy Desktop allow users to do? Answer:   Using Microstrategy Desktop, users can easily access and share critical corporate information they need to make cost-cutting decisions..

Question.1  What is single LTS and multiple LTS? Answer:  The logical table created at the BMM layer can be based on the data from a single physical layer table, when it is called single Logical Table source. When the specific logical layer table is dependent on the columns of different..

Question.1   What is ASP? Answer:   Active Server Pages (ASP), also known as Classic ASP, is a Microsoft’s server-side technology, which helps in creating dynamic and user-friendly Web pages. It uses different scripting languages to create dynamic Web pages, which can be run on any type of browser. The Web pages..

Question.1  What is the difference between connected and unconnected transformation? Answer:   Connected Transformation: Connected transformation is connected to other transformations or directly to target table in the mapping. Unconnected Transformation: An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns..

Qustion.1   Explain Qlikview architecture? Answer:  QlikView deployments have three main infrastructure components: 1.QlikView Developer :  Is a Windows-based desktop tool that is used by designers and developers to create a) a data extract and transformation model and b) to create the  graphical user interface (or presentation layer). 2.QlikView Server (QVS)..

Question.1  What is the difference between FastLoad and MultiLoad? Answer:  FastLoad uses multiple sessions to quickly load large amount of data on empty table. MultiLoad is used for high-volume maintenance on tables and views. It works with non-empty tables also. Maximum 5 tables can be used in MultiLoad. Question.2  Which..

Question.1 Define repository in terms of OBIEE? Answer:  Repository stores the Meta data information. The extension of the repository file is “.rpd”.   With OBIEE Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business..