why cant we put a sequence generator or upd strategy transformation before joi

why cant we put a sequence generator or upd strategy
transformation before joiner transformation?

Question Posted / chandra

2 Answers
16539 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Is This Answer Correct ?

5 Yes

7 No

why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Answer / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer