how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
What are the different options available for update strategy?
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 session parameters ? How do you set them?
Implementation methodology
Why do we need informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the scenario which compels informatica server to reject files?
What are the types of lookup transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
can you please explain me pre session and post session options?
What is the surrogate key?
What is difference between a gateway node and worker node?
What are the limitations of joiner transformation?
What do mean by local and global repository?
what is mean by complex business rule ?