how do u fnd the duplicate rows and how to delete the
duplicate rows?
- 2 Answers
- 7544 Views
- IBM, I also Faced
- E-Mail Answers
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 types of caches in lookup? Explain them.
What is the maplet?
Which development components of informatica have the highest usage?
Can you use flat files in Mapplets.
what is the Default Source Option For Update Strategy Transformation?
Differentiate between source qualifier and filter transformation?
What do you understand by term role-playing dimension?
How many dimensions are there in informatica?
Explain lookup transformation source types in informatica
Is it possible to create multiple domains on a single Informatica server?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the different lookup cache(s)?
Which transformation is needed while using the Cobol sources as source definitions?
What are the advantages of using informatica as an etl tool over teradata?
How to update a particular record in target with out running whole workflow?
