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 |
Explain sessions and how many types of sessions are there?
can we have to do changes in session property when we are dynamically generating target files?
Differentiate between a repository server and a powerhouse?
how did u understand business requirement?
what is the predefined port in dynamic lookup
Where do you create/define mapping parameter and mapping variable?
Which version configuration tool used in ur project?
What is data caches/ index caches?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
how to load dimension table and fact table. plz tell me the steps.
What are the new features of informatica 9.x at the developer level?