The source qualifier Trns has select distinc option from thr we can elimina

how eliminate the duplicates in flat file with out using
sorter ,aggregater

Question Posted / krishna

Answer Posted / krishna

The source qualifier Trns has select distinc option from thr we can eliminate duplicates

Is This Answer Correct ?

6 Yes

38 No

Please Help Members By Posting Answers For Below Questions

Explain transaction control transformation in informatica

1269

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7067

What are the restrictions of union transformation?

1041

How to join three sources using joiner?

1115

What is an aggregator transformation?

1097

Explain the pipeline partition with real time example?

1144

What are the types of lookup transformation?

1081

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1283

how we can load rejected record's at run time?(not through bad files)

2380

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4110

What is meant by a domain?

1129

How can we delete duplicate rows from flat files?

1223

How to handle decimal places while importing a flatfile into informatica?

1192

What is meant by lookup transformation?

1110

How many transformations can be used in mapplets.

1935