my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?

Answer Posted / dharmendra singh

Use a sorter transformation after source qualifier.check
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to differentiate between the active and passive transformations?

627


Differentiate between router and filter transformation?

613


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1698


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2283


What are the popular informatica products?

653






How can we use mapping variables in informatica?

597


What is an expression transformation in informatica?

519


What are junk dimensions?

634


What is the difference between a connected look up and unconnected lookup?

575


define galaxy repository in informatica

1729


Explain the different kinds of facts.

566


differences between service based and product based?

1565


Differentiate between reusable transformation and mapplet.

575


What do you mean by worklet?

633


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

563