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
- 29468 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 can we delete duplicate rows from flat files?
What are active and passive transformations?
What are the differences between joiner transformation and source qualifier transformation?
Design a mapping to load a target table with the following values from the above source?
What is the cumulative sum and moving sum?
What is meant by query override?
What are the different types of repositories created using informatica?
how we can load rejected record's at run time?(not through bad files)
What are the tasks that source qualifier perform?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is workflow? What are the components of the workflow manager?
What is union transformation in informatica?
Explain the pipeline partition with real time example?
What are the tasks that can be performed using sq?
