ETL TESTING INTERVIEW QUESTIONS AND ANSWERS

ETL TESTING MOST ASKED Job Interview Questions. Read ETL TESTING Interview Questions and Answers for Experienced, Freshers PDF Download.

Read ETL TESTING Questions and Answers for Interview

What is a Data Warehouse?View Answer
What is a Data mart?View Answer
What is OLAP?View Answer
What is OLTP?View Answer
What are Dimensions?View Answer
What are Confirmed Dimensions?View Answer
What are Fact Tables?View Answer
What are the types of Facts?View Answer
What are the types of Fact Tables?View Answer
What is Grain of Fact?View Answer
What is Factless Fact table?View Answer
What are Measures?View Answer
What are Cubes?View Answer
What are Virtual Cubes?View Answer
What is a Star schema design?View Answer
What is Snow Flake schema Design?View Answer
What is Operational Data Store [ODS] ?View Answer
What is Denormalization?View Answer
What is Surrogate Key?View Answer
What are the client components of Informatica 7.1.1?View Answer
What are the server components of Informatica 7.1.1?View Answer
What is Metadata?View Answer
What is a Repository?View Answer
What is Data Acquisition Process?View Answer
What are the GUI based ETL tools?View Answer
What are programmatic based ETL tools?View Answer
What is a Transformation?View Answer
What are the various tools? Name a few?View Answer
What are features of Informatica Repository Server?View Answer
What is a Work Flow?View Answer
What is the uses of Lookup Transformation?View Answer
What are the different sources of Source systems of Data Warehouse?View Answer
Types of Slowly Changing Dimensions:View Answer
What are Update Strategy’s target table options?View Answer
What does a Mapping document contains?View Answer
What does the Top Down Approach says?View Answer
What does the Bottom Up Approach or Ralph Kimball Approach says?View Answer
Who is the first person in the organization to start the Data Warehouse project?View Answer
What is a Dimension Modeling?View Answer
What are the types of OLAPs ?View Answer
What is worklet?View Answer
Why we use lookup transformation?View Answer
What is a Power Center Repository?View Answer
What are snapshots? What are materialized views & where do we use them? What is a materialized view?View Answer
Where do we use connected and unconnected lookups?View Answer