ETL Interview Questions
Questions Answers Views Company eMail

What are the three tiers in etl?

586

What are dimensions?

573

What are the steps involved in etl process?

513

What is initial load and what is full load?

514

Explain different types of partitioning?

617

List few etl bugs?

523

What are three tier systems in etl?

616

What are your responsibilities as an etl tester?

623

What is grain of fact?

540

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’?

520

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

571

Mention few test cases and explain them?

541

Explain etl mapping sheets?

656

What is tracing level and what are the types?

532


Post New ETL Questions

Un-Answered Questions { ETL }

how to load the data to fact table?

2149


what are the types in error loging?

1631


What are the various tools used in etl?

544


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1447


What is etl process?

530






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

1634


dimension object created in oracle can be imported in designer?how?

2453


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

1833


what is a worklet?

541


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1652


What are the ETL Testing Operations?

616


what are the reports developed in sap bw project and what is the requirement for developing it?

1774


what is the meant by Normalization and de-normalization?

2231


Can we create Hierarchies in generic datasources?

1924


how do u really know that paging to disk is happening while u are using a lookup transform?

2041