Data Warehousing Interview Questions and Answers

  • Informatica Interview Questions with answers

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


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Datastage Interview Questions with answers

    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…


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Informatica Interview questions with answers

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Microstrategy Interview Questions and answers for Experienced

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • OBIEE Interview Questions and answers for Experienced

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • ASP.NET interview questions and answers

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Informatica Interview Questions and answers for experienced

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Qlikview Interview Questions and answers

    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 1) a data extract and transformation model and 2) to create the  graphical user interface (or presentation layer). 2.QlikView Server (QVS)..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • Teradata Interview Questions and answers

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

  • OBIEE Interview Questions and Answers |Oracle BI Interview Questions

    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..


Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

Quick Enquiry
We resond as soon as possible.
2016 (C) All rights reserved.
Submit your details
2017 (C) All rights reserved.
GET THIS OFFER