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
- 29358 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
How to differentiate between the active and passive transformations?
What is the difference between informatics 7x and 8x and what is latest version?
How union transformation is used?
What is a mapplet/worklet in informatica?
how to load dimension table and fact table. plz tell me the steps.
Define Pmrep command?
How do you use reject loader.
What is the difference between a connected look up and unconnected lookup?
Explain dynamic target flat file name generation in informatica
What are the different versions of informatica?
What are the types of presistent cache in look up tr.
What is a sequence generator transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are data-driven sessions?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
