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
No Answer is Posted For this Question
Be the First to Post Answer
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain me ETL project architecture in Detail?
When do we go for the tools in the market?
What is a lookup table in etl?
how many maximum session supports to multiload in teradata ??
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
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.
what is the advantage of persistent cache? when it should be used?
What do you understand by the term ‘transformation’?
what are the data modeling tools you have used?(polaris)
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you