how can we use sorter transformation in joins?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / x
Hi,
In joiner T/S properties we have an option called sorter
input.
So by using this we can improve the session Performance
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / m
To improve the perfomance we have to check the button "sorted input" ,
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sreekanth
to eliminate duplicates also sorter transformation is used
Is This Answer Correct ? | 2 Yes | 0 No |
What is diff joiner and lookup
How to recover sessions in concurrent batches?
How can one identify whether mapping is correct or not without connecting session?
How do we call shell scripts from informatica?
What are the options in the target session of update strategy transsformatioin?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is target update override
Why sorter is an active transformation?
what is the process we used in joiner transformation,there is no matching column in sources?
what is the incremental agrrigation?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
How big was your fact table