What are the challenges you have faced in your Project (DWH-
ETL)? Explain with example?


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

Post New Answer

More Informatica Interview Questions

Explain sessions. Explain how batches are used to combine executions?

0 Answers  


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


what is the monster dimension plz give me one example

2 Answers   EDS,


what are the output files that the informatica server creats during running a session?

2 Answers   CTS,






I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,


what is confirmed fact?

2 Answers  


What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


Is there any target staging area in informatica not staging area

0 Answers   Syntel,


How many number of sessions can one group in batches?

0 Answers  


Categories