How to eliminate duplicates in FF and oracle both
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain sql transformation in script mode examples in informatica
can we override a native sql query within informatica? Where do we do it?
What is a repository? And how to add it in an informatica client?
How do you load only null records into target?
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
write a query to retrieve the latest records from the table sorted by version(scd)
How you can differentiate between connected lookup and unconnected lookup?
To import the flat file definition into the designer where should the flat file be placed?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Briefly describe lookup transformation?
What is data transformation manager process?
What is primary and backup node?
What is deployment group?
What are active transformations.