Interested to Buy Any Domain ? << Click Here >> for more details...
if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
- 8 Answers
- 29096 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jhilam roy
Simple answer: NO, provided, only the Aggregator
transformation is used.
In an Aggregator transformation, if no port is selected as
Group By, then by default, the PowerCenter Sever returns the
very last row of the input record set, definitely not the
first one.
It scans sequentially starting from the first port of the
input set and continues till the last port is hit. If it
fails to find any port designated as Group By, the default
nature is to return the last record of the input record set
to the downstream transformation or target.
Any updation is appreciated.
Jhilam
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
How we can create indexes after completing the loan process?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to load data in informatica ?
Parameter and variable differences
Explain direct and indirect flat file loading (source file type) - informatica
Explain the code page compatibility?
can anyone suggest best free Talend data integration training online
Explain pushdown optimization $pushdownconfig parameter - informatica
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?
Explain about Informatica server process that how it works relates to mapping variables?
What all are steps in up gradation of Informatica server?
What are the guidelines to be followed while using union transformation?
What is the use of code page?
