how can we use sorter transformation in joins?
Answer Posted / prasuna
You can improve session performance by configuring the
Joiner transformation to use sorted input.
To configure a mapping to use sorted data, you establish and
maintain a sort order in the mapping so the Integration
Service can use the sorted data when it processes the Joiner
transformation.
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is meant by active and passive transformation?
what is $$$$?
What are the various types of transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain the shared cache and re-cache?
Enlist the advantages of informatica.
Explain lookup transformation is active in informatica
Could you explain what is enterprise data warehouse?
How many ways are there to create ports?
What are the components of Informatica? And what is the purpose of each?
Explain why we use partitioning the session in informatica?
What is the fact table?
Why filter transformation is an active one?