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 function of aggregator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can you define user defied event?
What are the main issues while working with flat files as source and as targets ?
How do you load first and last records into target table?
What is the meaning of decode in informatica?
Define the various join types of joiner transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Could you explain what is enterprise data warehouse?
What are the features of complex mapping?
What is a surrogate key?
What can we do to improve the performance of informatica aggregator transformation?
Which development components of informatica have the highest usage?