What is the method of seperating unique and duplicate
records in session level?
Answers were Sorted based on User's Feedback
Answer / jz
Select Distinct Box at Source propeties level or jus
override sql in Session.
Is This Answer Correct ? | 17 Yes | 3 No |
Answer / priya yadav
Hi,
I am not aware at session level but I can tell you the same
at mapping level.
Either Select Distinct in SQ itself or in expression, u can
use a variable v1 to store the business keys of the
records. This will store the business keys(based on which
you have to determine a record as duplicate) of the record
v1= A||B||C
Assign this to another variable v2. This will assign these
business keys to v2.
v2=v1( Now v2 will have value A||B||C)
Set Duplicate Flag as Y if V1= V2 else N.
Now the business keys are stored in v2. Next time the
record will come it will calculate v1 on basis of business
keys, if that record is duplicate v1=v2, and record will be
marked for duplicate. If the record has different business
keys then v1 <> v2, and the record will not be marked as
dupliacte.
Hope it helps.
Thankyou!!
Priya Yadav
Is This Answer Correct ? | 0 Yes | 0 No |
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is facttable granularity?
What do you mean by blocking transformation?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Briefly explain the aggregator transformation?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is event and what are the tasks related to it?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
Can we make worklet inside worklet?
How can you differentiate between powercenter and power map?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc