Tuesday, 3 February 2015

ETL data warehouse testing interview questions Part4

31. What is the uses of Lookup Transformation?
The Lookup Transformation is useful for:
1.     Getting a related value form a table using a key column value
2.     Update slowly changing dimension table
3.     To check whether records already exists in the table.

32. What are the different sources of Source systems of Data Warehouse?
Flat Files
XML Files
Web Methods
Web Services
Cobol Files
Legacy Systems.

33. Types of Slowly Changing Dimensions:
Type – 1 (Recent updates)
Type – 11 (Full historical information)
Type – 111 (Partial historical information)

34. What are Update Strategy’s target table options?
Update as Update: Updates each row flagged for update if it exists in the table.
Update as Insert: Inserts a new row for each update.
Update else Insert: Updates if row exists, else inserts.

35. What does a Mapping document contains?
The Mapping document contains the following information :
Source Definition – from where the database has to be loaded
Target Definition – to where the database has to be loaded
Business Logic – what logic has to be implemented in staging area.

36. What does the Top Down Approach says?
The Top Down Approach is coined by Bill Immon. According to his approach he says “First we need to implement the Enterprisedata warehouse by extracting the data from individual departments and from the Enterprise data warehouse develop subject oriented databases called as “Data Marts”.

37. What does the Bottom Up Approach or Ralph Kimball Approach says?
The Bottom Down Approach is coined by Ralph Kimball. According to his approach he says “First we need to develop subject oriented database called as “Data Marts” then integrate all the Data Marts to develop the Enterprise data warehouse.

38. Who is the first person in the organization to start the Data Warehouse project?
The first person to start the Data Warehouse project in a organization is Business Analyst.

39. What is a Dimension Modeling?
A Dimensional Modeling is a high level methodology used to implement the start schema structure which is done by the Data Modeler.

40. What are the types of OLAPs ?
DOLAP: The OLAP tool which words with desktop databases are called as DOLAP. Example: Cognos EP 7 Series and Business Objects, Micro strategy.
ROLAP: The OLAP which works with Relational databases are called as ROLAP. Example: Business Object, Micro strategy, Cognos ReportNet and BRIO.
MOLAP: The OLAP which is responsible for creating multidimensional structures called cubes are called as MOLAP. Example: Cognos ReportNet.
HOLAP: The OLAP which uses the combined features of ROLAP and MOLAP are called as HOLAP. Example Cognos ReportNet.
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5

No comments:

Post a Comment