Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh
if the source is database means we can delete the duplicate
records by enabling the option select distinct in source
qualifier t/r properties or by writing the following query
in source qualifier filter
delete from emp where rowid not in (select min(rowid) from
emp group by empno);
if the source is flat file means by enabling the option
distinct in sorter t/r we can delete the duplicate records
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
What are mapplets?
What is powercenter on grid?
Can we get 1st record through Informatica(without sequence number).
How many ways are there to do 'remove duplicate records in informatica'?
What is status code in informatica?
What will be the approach?
explain abt ur project architecture?
How many types of sessions are there in informatica.please explain them?
How might one distinguish in the case of mapping is right or not without associating session?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What could be the possible resons of locks by user?
define galaxy repository in informatica
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?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is union transformation in informatica?
