Interested to Buy Any Domain ? << Click Here >> for more details...
If u select groupby port in aggregator what is output and
dont select groupby option what is output
- 2 Answers
- 5718 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
If we select a group by port then : we get the last row of
each group based on the group by port.
If we didn't select a group by port: we get only one row
that is the last row .
| Is This Answer Correct ? | 12 Yes | 1 No |
what is the size of u r project? and what is the size of source file?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
How can you increase the performance in joiner transformation?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
How to load only the first and last record of a flat file into the target?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
How to use procedural logic inside infromatica?
how many types transformations supported by sortedinput?
I have source like this 1:2;3. so i want to load the target as 123
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!
what is the difference between Informatica7.1 & informatica 8.1
How to do the error handling of if ur source is flatfiles?
Teradata 
