How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?

Answer Posted / prasad

u can use unix command in pre session as sort -u file1
>newfile

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Rank index port in Rank transformation?

646


How we can create indexes after completing the load process?

584


Parameter and variable differences

1597


can u give example for factless fact table

5471


What do you mean by channel change?

513






Informatica settings are available in which file?

568


Is it possible to revert a global repository to local one and why?

591


Define mapplet?

607


What are the advantages of using informatica as an etl tool over teradata?

545


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

578


What are data-driven sessions?

687


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

572


Global and Local shortcuts. Advantages.

1438


What are the different transaction levels available in transaction control transformation?

645


What is substr in informatica?

635