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 a transforamation?
How big was your fact table
What are active transformations? Name them.
Explain the difference between a data warehouse and a data mart?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
What are pre and post-session shell commands?
why u go for dimensions ?
Define joiner transformation?
difference between repository database and repository service?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Why we use lookup transformations?
Slowly changing dimensions, types and where will you use them