How to extract original records at one target & Duplicate
records at one target?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / saradhi
As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.
| Is This Answer Correct ? | 0 Yes | 5 No |
What is polling in informatica ?
without matching columns in two tables. how can you join
What are the data movement modes in informatica?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by pre and post session shell command?
what is the difference between onsite & client site?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
How to list Top 10 salary, without using Rank Transmission?
can we create index and drop index in exsisting table while using infomatica
Explain the shared cache and re-cache?