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 |
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Is it possible to use a client with different version than that of its Informatica server?
Have you worked with/created Parameter file
How to enter same record twice in the target table,explain?
what is distinct
What is union transformation?
Router T/R is active but some people are saying it is also passive which is exactly right?
What are the types of schemas we have in data warehouse.
what is scd?
What is polling?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
How to read data from flat file source if the data is in paragraph format?