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
How does the aggregator transformation handle null values?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is intricate mapping?
What is the difference between informatica 7.0 and 8.0?
explain about unit testing? in real time?
What is the surrogate key?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is lookup transformation?
What is a passive transformation?
Explain lookup transformation is active in informatica
Is there any way to read the ms excel datas directly into informatica?
What is target load order?
What are batches?
Can informatica load heterogeneous targets from heterogeneous sources?
is it possible to index the data in cache of lkp transformation ?