How to extract original records at one target & Duplicate
records at one target?
Answer Posted / rag
Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Under what condition selecting sorted input in aggregator may fail the session?
What are the data movement modes in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Under which circumstances, informatica server creates reject files?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a surrogate key?
What is domain in terms of informatica?
Mention few power centre client applications with their basic purpose?
Explain the difference between a data warehouse and a data mart?
How many ways are there to do 'remove duplicate records in informatica'?
What is option by which we can run all the sessions in a batch simultaneously?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is the -ve test case in your project.
What are data-driven sessions?