Hi,
I have a source and from there am applying some transformations and finally loading data to target.
I have a update strategy that i want to update all the target coloumns 'NULLS' except one column.So I created a condition which makes all columns in update strategy and loads the null value in to variable.
Now I want to connect the Null valued port to the target. As I have 100 no. of columns in target i want to connct the null value port to the tageet columns at the same time.
How can i do it at a time(Like Auto Kink)I can't use auto link as i have one anoter column to which i need to assign some other port and for remaining only one port.
Pls advice...
I have a source and from there am applying some transformations and finally loading data to target.
I have a update strategy that i want to update all the target coloumns 'NULLS' except one column.So I created a condition which makes all columns in update strategy and loads the null value in to variable.
Now I want to connect the Null valued port to the target. As I have 100 no. of columns in target i want to connct the null value port to the tageet columns at the same time.
How can i do it at a time(Like Auto Kink)I can't use auto link as i have one anoter column to which i need to assign some other port and for remaining only one port.
Pls advice...