How can we eliminate duplicate rows from flatfile,explain?

Answer Posted / nagaraj.g

using sorter transformation for distinct in a flat files

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the layout of parameter file (what does a parameter file contain?)?

1918


What are the steps involved in the migration from older version to newer version of Informatica Server?

1589


What is transformation?

663


What is the difference between STOP and ABORT options in Workflow Monitor?

699


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1482






How can we improve session performance in aggregator transformation?

678


Is there any way to read the ms excel datas directly into informatica?

552


What is domain in terms of informatica?

567


Suppose we do not group by on any ports of the aggregator what will be the output?

582


What is a dimensional model?

584


Differentiate between sessions and batches?

578


How to extract sap data using informatica? What is abap? What are idocs?

560


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

735


Explain about cumulative Sum or moving sum?

624


What are the limitations of joiner transformation?

657