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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Write the unconnected lookup syntax?
What does command task mean?
What is resilience time?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain informatica architecture - version 8 / 9
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can informatica be used for an organization?
How can we use mapping variables in informatica? Where do we use them?
What are the reusable transformations?
How do you load unique records into one target table and duplicate records into a different target table?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different types of olap? Give an example?
What are active transformations.
What are the guidelines to be followed while using union transformation?
