If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?
Answer Posted / akhil4
session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Why sorter is an active transformation?
can we override a native sql query within informatica? Where do we do it?
What is powercenter on grid?
What is the difference between informatics 7x and 8x and what is latest version?
How you can differentiate between connected lookup and unconnected lookup?
Which are the different editions of informatica powercenter that are available?
According to his methodology what all you need before you build a datawarehouse
Explain the types of transformations?
What differs when we choose the sorted input for aggregator transformation?
Explain informatica architecture - version 8 / 9
What is the need for an etl tool?
How does the aggregator transformation handle null values?
Explain the etl program with few examples.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain what is informatica metadata and where is it stored?