How to eliminate duplicates in FF and oracle both
- 3 Answers
- 6485 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Please let me know how to make encryption and decryption with example?
Define pmcmd command?
How many repositories can be created in informatica?
Plz can any one say me how to get the informatica certification materials and dumps
What is data movement mode in Informatica and difference between them?
Can we make worklet inside worklet?
What are the tasks that source qualifier performs?
What is data caches/ index caches?
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
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is confirmed dimension?
According to his methodology what all you need before you build a datawarehouse
Teradata 
