Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7075 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 the difference between informatica 7.0 and 8.0?
Mention few power centre client applications with their basic purpose?
Make a note of the quantity vaults made in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Did u used latest transformations of 8.6.0? for what?
What is the difference between router and filter?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to call shell scripts from informatica?
differences between service based and product based?
What is the need of an ETL tool?
What is meant by target load plan?
what is song in infrmatica...?
Can we create multiple integration service on single repository?
