ETL Interview Questions
Questions Answers Views Company eMail

Do we need an ETL tool? When do we go for the tools in the market?

700

Compare ETL & Manual development?

711

What are the different Lookup methods used in Informatica?

658

What are the types of Data Warehouse applications?

687

What are the key benefits of ETL Testing?

729

What is cube grouping?

737

What is virtual Data Warehousing?

718

What are the modules in Power Mart?

702

Define slowly changing dimensions (SCD)?

795

What is the difference between Data Warehousing and Data Mining?

740

What is the difference between round-robin partitioning and hash partitioning?

721

What is fact? What are the types of facts?

695

What is staging area referring to?

760

How etl testing is different from database testing?

709

What are cubes and olap cubes?

736


Post New ETL Questions

Un-Answered Questions { ETL }

what is the use of server manager?

1784


How to fine tune mappings?

712


flat filevalidation in informatica

1895


Define slowly changing dimensions (SCD)?

795


What is partitioning? Explain different types of partitioning?

847






What is a staging area? What is the purpose of a staging area?

667


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2340


When do we go for the tools in the market?

710


how would u estimate the size of Lookup transform data and index cache?

1830


How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2014


Identifying the bottlenecks in various components of Informatica and resolving them.

2362


what is pmrep command?

2095


what is the difference steps for data modeling?

1758


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1716


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1517