Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7374 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
What is informatica worklet?
What are the different transaction levels available in transaction control transformation?
update strategy transformation in informatica
Explain constraint based loading in informatica
What are the informatica performance improvement tips
What is powercenter on grid?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to load last n records of file into target table - informatica
How many types of sessions are there in informatica.please explain them?
What are the tuning techniques you applied during your last project
Why is sorter an active transformation?
What is a stored procedure transformation?
what is size of u r database?
How are indexes created after completing the load process?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
