how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 17505 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit kumar pradhan
if it is a relational source then click on source Qualifier
properties then check Distinct option.
if it is a flat file then it can't work .......
click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
Differences between version 7.x and 8.x.
Different qualification between a related rotate toward the sky and isolates look upward?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the types of caches in lookup?
Could you explain what is enterprise data warehouse?
What do you understand by SOA of Informatica?
Explain what are the different types of transformation available in informatica.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Informatica settings are available in which file?
What is meant by lookup transformation? Explain the types of lookup transformation?
Make a note of the quantity vaults made in informatica?
What is an active transformation?
explain abt ur project architecture?
