In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
Answer Posted / suneelkumar.dasari
If u enable the sorted input first of all burden on session will decrease and in sorted order aggregate data will come.
If u disable the sorted input port first first row type aggregate data and second row type aggregate date will come.But session won't fail.
Correct me if i am wrong.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
What is the Process to creating lookup transformation in informatica
server hot-ws270 is connect to Repository B. What does it mean?
Explain the shared cache and re-cache?
How many number of sessions can one group in batches?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Suppose we do not group by on any ports of the aggregator what will be the output?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How to go to the older version for a mapping?
Mention few advantages of router transformation over filter transformation.
What are the modules in Power Center
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?