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
What is the command used to run a batch?
4 yrs etl devloper roles and responsibilities?any body give solutions
What happens when a session fails and you click on recover?
Explain the types of lookup transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the static cache and dynamic cache in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What will be the approach?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is transformation?
How can we delete duplicate rows from flat files?
What are the conditions needed to improve the performance of informatica aggregator transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is source qualifier transformation in informatica?