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
- 3738 Views
- I also Faced
- E-Mail Answers
Reusable transformation and shortcut differences
What is a filter transformation?
Explain about HLD and LLD ?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
how we load the data from source to staging area
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
How can we remove the duplicates from flat file source?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What is the use of an aggregator cache file?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What is joiner cache?
Teradata 
