ETL Interview Questions
Questions Answers Views Company eMail

What are the three tiers in etl?

586

What are dimensions?

575

What are the steps involved in etl process?

513

What is initial load and what is full load?

516

Explain different types of partitioning?

617

List few etl bugs?

523

What are three tier systems in etl?

619

What are your responsibilities as an etl tester?

623

What is grain of fact?

541

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

549

What do you understand by the term ‘transformation’?

522

Explain the key challenges that you face while performing etl testing.

571

Mention few test cases and explain them?

545

Explain etl mapping sheets?

658

What is tracing level and what are the types?

535


Post New ETL Questions

Un-Answered Questions { ETL }

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

542


What is tracing level? How many types of transformations supported by sorted input?

546


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1666


what are the reporting tools and difference between them?

1587


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?

1551






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

2170


where is the cache (lookup, index) created and how can you see it.

1563


what is data modeling?

1898


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

1512


Explain etl mapping sheets?

658


What are various etl tools in the market?

523


what is a worklet?

543


Is apache nifi an etl tool?

545


where are the log files generally stored.Can you change the path of the file.what can the path be?

1926


what are the concerns of OLTP and DSS systems?

1969