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
- 8029 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 is the Default Source Option For Update Strategy Transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Enlist the various types of transformations.
What are the designer tools for creating transformations?
Differentiate between Load Manager and DTM?
How would you copy the content of one repository to another repository?
What is Data Caches size?
How do you load only null records into target? Explain through mapping flow.
How do you handle two sessions in Informatica
What is aggregate cache in aggregator transformation?
What are the modules in Power Center
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How many numbers of sessions can one group in batches?
What is the reusable transformation?
What are the types of presistent cache in look up tr.
