ETL Interview Questions
Questions Answers Views Company eMail

When do we analyze the tables? How do we do it?

707

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

695

What is etl process? How many steps etl contains?

772

How many steps etl contains?

691

What is a mapping?

752

What are materialized views & where do we use them?

675

State the differences between shortcut and reusable transformation

717

Explain about round-robi?

841

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

840

What is a materialized view log?

715

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?

703

What are snapshots?

733

What are the differences between sql override and update override?

741

What is partitioning? Explain about round-robin, hash partitioning.

715

Explain about hash partitioning?

723


Post New ETL Questions

Un-Answered Questions { ETL }

what is pmrep command?

11092


Explain the use lookup tables and Aggregate tables?

704


What are the key benefits of ETL Testing?

729


Is hadoop a etl tool?

655


how do use session mapping parameters ?(in which transformation)

1620






what is the difference steps for data modeling?

2263


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1972


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2012


How many steps etl contains?

691


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1501


what is data modeling?

2049


how many steps are there in etl process?

710


What is etl process. How many steps etl contains explain with example?

680


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1865


what is the difference steps for data modeling?

1758