Interested to Buy Any Domain ? << Click Here >> for more details...
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????
- 3 Answers
- 7858 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
when u want to perform calculations on groups u can go for
aggregator t/r.aggregate functions like
min,max,last,first,count ...
if u are not selected groupby the integration service returns
last record from all input rows.
why means that integration service rule.
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain Dataware house architecture .how data flow from intial to end?
What are multi-group transformations?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can you generate sequence numbers without using the sequence generator transformation?
What is a router transformation?
What are the tuning techniques you applied during your last project
Target increases every day even though no new record was inserted
Implementation methodology
What is rank index in rank transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many numbers of sessions can one group in batches?
What do you mean by channel change?
What is exclusive and normal mode for repository services?
