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
- 6803 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 Session and Batches?
What do you understand by term role-playing dimension?
Explain pushdown optimization and types in informatica
What is lookup change?
Implementation methodology
What is a repository? And how to add it in an informatica client?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the guidelines to be followed while using union transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to do unit testing in informatica?
What is the use of code page?
How do you load first and last records into target table?
Can u generate reports in Informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
