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
What is sequence generator transformation in informatica?
How to open an older version of an object in the workspace?
How do you load alternate records into different tables through mapping flow?
Enlist some properties of sessions.
Explain the code page compatibility?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a filter transformation and why it is an active one?
How do you update the records with or without using update strategy?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can we create a Integration service without a Repository service and vice versa?
How do you load only null records into target?
How to generate sequence numbers without using the sequence generator transformation?
What is rank transformation in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the different types of repositories created using informatica?