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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

Define slowly changing dimensions (SCD)?

0 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  


What are the different etl testing categories as per their function?

0 Answers  


What is a materialized view log?

0 Answers  






Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  


What are the types of Data Warehouse applications?

0 Answers  


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


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

0 Answers   Accenture,


In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  


Explain different types of partitioning?

0 Answers  


Categories