Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7276 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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the advantage of informatica?
What is the command used to run a batch?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
how to create user defined function (udf) in informatica
What is informatica metadata and where is it stored?
Mention some types of transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
In which transformation you cannot drag ports into it?
What is the use of an aggregator cache file?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is an Integration service in Informatica?
How do we call shell scripts from informatica?
What is a difference between complete, stop and abort?
What are the differences between source qualifier and joiner transformation?
