how will you remove the duplicate records from flat file
without using sorter?
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
State the differences between sql override and lookup override?
which one is better performance wise joiner or look up
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
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the maplet?
How to generate sequence numbers?
When do you use sql override in a lookup transformation?
Have you worked with/created Parameter file
What is the session task and command task?
How to load a Dimension ? and how to load a fact table?
What is the commit type if you have a transaction control transformation in the mapping?
explain abt ur project architecture?
How to update a particular record in target with out running whole workflow?
Write the advantages of partitioning a session?
How to extract sap data using informatica? What is abap? What are idocs?