How to eliminate duplicates in FF and oracle both
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 |
What is the difference between sequential batch and concurrent batch and which is recommended and why?
why sequence generator should not directly connected to joiner transformation ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
1 lac of flat fles in source how to load target at a time?
How to call shell scripts from informatica?
How to eliminate 1st and last rows from the source and load the inbetween rows.
What are the types of caches in lookup?
What is a repository? And how to add it in an informatica client?
What is sequence generator transformation in informatica?
How to fix the etl bugs..Tell me the process?
What is option by which we can run all the sessions in a batch simultaneously?
can we use mapplet as starting n ending object in mapping