how do u fnd the duplicate rows and how to delete the
duplicate rows?
Answer Posted / sankar
repet(more then one time) the rows is duplicate rows,
there r many ways to dele the duplicate rows
1.in source qualifies t/r select the DISTINC option
2.in aggreter t/r select the group by port
3.in sorter t/r select the distinc
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What can we do to improve the performance of informatica aggregator transformation?
What is repository manager?
Under what condition selecting sorted input in aggregator may fail the session?
What are active and passive transformations?
Reusable transformation and shortcut differences
what is the size of your data warehousing?
What is status code in informatica?
What is transformation?
Why filter transformation is an active one?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain load alternative records / rows into multiple targets - informatica
What are the types of data warehouses?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?