If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / srinu
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 57 Yes | 4 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What if the source is a flat-file?
What are the transformations that are not supported in mapplet?
Tell me about Propagate functions in informatica
Please let me know how to make encryption and decryption with example?
What does reusable transformation mean?
what is mean by complex business rule ?
What is the Rank index port in Rank transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a filter transformation and why it is an active one?
What is the use of an aggregator cache file?
What is joiner transformation in informatica?
What is the sequence generator transformation in informatica?
How many number of sessions can one group in batches?