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
How can we update a record in the target table without using update strategy?
what is unit testing?tell me proceedure
Differentiate between router and filter transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is workflow manager?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Enlist some properties of sessions.
Explain direct and indirect flat file loading (source file type) - informatica
What is the use of target designer?
What is resilience time?
What are the reusable transformations?
Plz can any one say me how to get the informatica certification materials and dumps
What is informatica powercenter repository?
Explain sessions and how many types of sessions are there?