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

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,


What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


What the difference is between a database, a data warehouse and a data mart?

0 Answers  


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,






what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


How will you update the row without using update statergy?

10 Answers   CTS,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


What is a repository manager?

0 Answers  


Categories