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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How can a transformation be made reusable?
How do you update the records with or without using update strategy?
Is it possible to revert a global repository to local one and why?
What is an expression transformation?
Differentiate between joiner and lookup transformation?
How do you migrate data from one environment to another?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Differentiate between reusable transformation and mapplet.
Differentiate between source qualifier and filter transformation?
Is there any way to read the ms excel datas directly into informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain about Informatica server process that how it works relates to mapping variables?
What is an aggregator transformation?
In how many ways we can create ports?