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


Please Help Members By Posting Answers For Below Questions

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679


What is meant by active and passive transformation?

587


what is $$$$?

1742


What are the various types of transformation?

646






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?

1692


Explain the shared cache and re-cache?

616


Enlist the advantages of informatica.

633


Explain lookup transformation is active in informatica

665


Could you explain what is enterprise data warehouse?

559


How many ways are there to create ports?

731


What are the components of Informatica? And what is the purpose of each?

624


Explain why we use partitioning the session in informatica?

617


What is the fact table?

594


Why filter transformation is an active one?

565