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 |
Can we make worklet inside worklet?
What is log file,and where is it located,why u r using the log file
What do you understand by SOA of Informatica?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
What are different types of transformations available in informatica?
What is data merging, data cleansing and sampling?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What are the types of schemas we have in data warehouse.
What are the diffrences between joiner transformation and source qualifier transformation?
Define sessions in informatica etl?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs