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 is the need of etl tools?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by blocking transformation?
What is the difference between a repository server and a powerhouse?
Explain load alternative records / rows into multiple targets - informatica
How to Create a folder using pmrep command?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How do you load only null records into target?
What are the different types of transformation available in informatica.
wat are deployement groups in informatica, how it will be used for developers
How can you increase the performance in joiner transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are connected or unconnected transformations?
Explain joiner transformation in informatica
explain abt ur project architecture?
