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
What is the Rank index port in Rank transformation?
What is a difference between complete, stop and abort?
Design a mapping to load a target table with the following values from the above source?
lookup transformation with screenshots
What all are steps in up gradation of Informatica server?
What is the Process to creating lookup transformation in informatica
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain sql transformation in script mode examples in informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is a code page?
How can we improve session performance in aggregator transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Explain joiner transformation in informatica
What do you mean by enterprise data warehousing?
Why filter transformation is an active one?