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 is a router transformation?
What is a passive transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is meant by active and passive transformation?
How to create Target definition for flat files?
What is informatica? Why do we need it?
What is the use of source qualifier?
What is a node in Informatica?
What is sorter transformation?
What is rank transformation in informatica
What are the different versions of informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is session task and command task?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is meant by a domain?