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 |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What are the phases in SDLC?
Why we use partitioning the session in informatica?
How do you load only null records into target? Explain through mapping flow.
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
What are the challenges you have faced in your project?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
how to use incremental load?
Can we use parameters of parameter file in presession command
How to recover the standalone session?
What is the Difference between sorter and aggregator?
How to improve the performance of a session using sorter transformation?