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 Cognos script editor?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What is the difference between informatica 8.x and 9.x
how to design mapping half of source table records into one target and remaining half into another target
What are the features of complex mapping?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
How many dimensions are there in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is the incremental agrrigation?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Why you use repository connectivity?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?