How to extract original records at one target & Duplicate records at one ta

How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important

Question Posted / pune.rohitsharma

4 Answers
9089 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to extract original records at one target & Duplicate records at one target? {with out usin..

Answer / usha

by using dynamic lkp its possible...

in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...

when ever data inserted in to the target cache get
refreshed..

we ttake dynamic lkp..
by defaul..new lkp row port is added...

we should enable the associatve port...

here we should give the condition ..

in router we should give condition as newlkp=1--it will
insert...

if newlkp=0 means duplicate recorts

Is This Answer Correct ?

5 Yes

0 No

How to extract original records at one target & Duplicate records at one target? {with out usin..

Answer / p1khatri

using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2

I hope this'll work

Is This Answer Correct ?

7 Yes

6 No

How to extract original records at one target & Duplicate records at one target? {with out usin..

Answer / yaseen

sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.

And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update

Plz correct me if I am wrong

Is This Answer Correct ?

1 Yes

0 No

How to extract original records at one target & Duplicate records at one target? {with out usin..

Answer / sankar

by using router transformation

Is This Answer Correct ?

4 Yes

11 No

Post New Answer