What are the restrictions of union transformation?


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

Post New Answer

More Informatica Interview Questions

What are the different threads in DTM process?

2 Answers  


How to delete duplicate records in a flat file source?

2 Answers  


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


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  


what is the difference between Informatica7.1 & informatica 8.1

4 Answers  






Can you access a repository created in previous version of Informatica?

1 Answers  


What are the different types of schemas?

11 Answers   ITC Infotech,


What is query panel?

1 Answers  


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  


Tell me about Propagate functions in informatica

0 Answers  


sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


Categories