Why cant we use a sequence generator or update strategy transformation before a joiner or union transformation?

Showing Answers 1 - 3 of 3 Answers

Vikas Dhakne

Dec 15th, 2016

UNION transformation combines 2 sets of same attributes. If you use sequence generator transformation before union, it will give duplicate values (because sequence is coming from different sets). hence, data will get rejected if target has primary key.

Generally, update strategy flags row for update, delete, that record type may change in union transformation, so we cant use update strategy before UNION transformation