Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Connect a single port to Multiple ports in Target at one time

Status
Not open for further replies.

venku72

Technical User
Sep 28, 2005
25
JP
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...

 
Are you serious about loading nulls in this fashion to a target? Did you consider not loading those ports?

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top