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
- 29205 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 is a repository? And how to add it in an informatica client?
Explain pushdown optimization and types in informatica
can we override a native sql query within informatica? Where do we do it?
Name the different lookup cache(s)?
What is substr in informatica?
What is flashback table ? Advance thanks
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the types of data warehouses?
What is the difference between STOP and ABORT options in Workflow Monitor?
Where do we use mapping variables in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
update strategy transformation in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Enlist the advantages of informatica.
What are the types of schemas we have in data warehouse and what are the difference between them?
