How to eliminate duplicates in FF and oracle both

Answers were Sorted based on User's Feedback



How to eliminate duplicates in FF and oracle both..

Answer / ravindra.15aug

In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.

In FF level also we can do except sql queary in source
qualifier.

Is This Answer Correct ?    9 Yes 0 No

How to eliminate duplicates in FF and oracle both..

Answer / akash

In addition to the above answers I will add one more option.

We can use expression to check whether a record is
repeating or not and set an output port as flag. For first
occurence of any record this flag is 1. Use router after
this with condition "i_FLAG = 1". This output will give
only unique records. Default output will give only
duplicate records.

Also we can use a filter after the above expression with
the condition "i_FLAG = 1"

Is This Answer Correct ?    3 Yes 0 No

How to eliminate duplicates in FF and oracle both..

Answer / priyank

For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.

In Oracle, use distinct in SQ sql override to remove the
duplicates.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Please let me know how to make encryption and decryption with example?

0 Answers  


Define pmcmd command?

0 Answers  


How many repositories can be created in informatica?

1 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


What is data movement mode in Informatica and difference between them?

0 Answers  


Can we make worklet inside worklet?

1 Answers  


What are the tasks that source qualifier performs?

1 Answers  


What is data caches/ index caches?

0 Answers  


write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  


What is confirmed dimension?

3 Answers  


According to his methodology what all you need before you build a datawarehouse

0 Answers  


Categories