Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7099 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
Differentiate between Load Manager and DTM?
To import the flat file definition into the designer where should the flat file be placed?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the cumulative sum and moving sum?
without table how to come first record only in oracle?
What is resilience time?
Enlist the tasks for which source qualifier transformation is used.
What are connected or unconnected transformations?
What are the new features of informatica 9.x developer?
How can a transformation be made reusable?
What do you mean by filter transformation?
scenario where i can use only concurrent execution of workflow.
What is rank index in rank transformation?
Explain the informatica workflow?
