how can we use sorter transformation in joins?

Answer Posted / sreekanth

to eliminate duplicates also sorter transformation is used

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the hint? how to use it to reduce the query processing in program?

6322


How can we handle two sessions in informatica?

616


How might one distinguish in the case of mapping is right or not without associating session?

642


waht type of interface is used for testing the data in informatica

1835


What is a joiner transformation?

560






hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1533


Explain pushdown optimization and types in informatica

672


Differentiate between joiner and lookup transformation?

619


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412


what is mean by complex business rule ?

1723


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1780


wat are deployement groups in informatica, how it will be used for developers

1262


On which transformations you created partitions in your project?

763


How can you increase the performance in joiner transformation?

713


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

630