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
- 6791 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
How can you validate all mappings in the repository simultaneously?
What are the types of caches in lookup?
What is the scenario which compels informatica server to reject files?
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?
What is an aggregator transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How many ways are there to do 'remove duplicate records in informatica'?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Is it possible to define a single node as a Gateway node as well as worker node?
What is the meaning of decode in informatica?
design of staging area?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are multi-group transformations?
What are the mapping parameters and mapping variables?
