how can we use sorter transformation in joins?

Answers were Sorted based on User's Feedback



how can we use sorter transformation in joins?..

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

how can we use sorter transformation in joins?..

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

how can we use sorter transformation in joins?..

Answer / rakesh

while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.

Is This Answer Correct ?    6 Yes 0 No

how can we use sorter transformation in joins?..

Answer / m

To improve the perfomance we have to check the button "sorted input" ,

Is This Answer Correct ?    2 Yes 0 No

how can we use sorter transformation in joins?..

Answer / sreekanth

to eliminate duplicates also sorter transformation is used

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is Cognos script editor?

0 Answers   Cognizant,


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.

10 Answers   Emirates, IBM,


What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,


What are the features of complex mapping?

0 Answers  






How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


How many dimensions are there in informatica?

0 Answers  


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

0 Answers  


what is the incremental agrrigation?

2 Answers   Cap Gemini,


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.....

3 Answers   TCS,


Why you use repository connectivity?

3 Answers   Yash Technologies,


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


Categories