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
Different circumstance which drives informatica server to expel records?
What is expression transformation?
What is sequence generator transformation in informatica?
Explain how many types of dimensions are available in informatica?
Write the unconnected lookup syntax and how to return more than one column.
What is the use of source qualifier?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differences between version 7.x and 8.x.
What are mapplets? How is it different from a Reusable Transformation?
How can we use batches?
State the limitations where we cannot use joiner in the mapping pipeline?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Global and Local shortcuts. Advantages.
What are the different transaction levels available in transaction control transformation?