What is the need for an etl tool?


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

Post New Answer

More Informatica Interview Questions

What is IQD file?

1 Answers  


why do u use shortcuts in informatica.?

4 Answers   iFlex,


How to partition the Session?

0 Answers   Informatica,


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  






How do you do error handling in Informatica?

1 Answers  


Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  


How can we delete duplicate rows from flat files?

0 Answers  


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


Explain the scenario which compels informatica server to reject files?

0 Answers  


Why we use stored procedure transformation?

4 Answers  


What is limitations of truncate and load option

1 Answers   Cap Gemini,


Categories