DSXchange

Hi , everybody !!!

I have a hashed file tha contains 1000 rows. Each run of some jobs insert into the file 10 rows and the option "Clear before writing" is unchecked.
I need to update each time these 10 rows .

The problem is all rows (each time therwea can be 90 that are different) get NULL values except the key fields.

Example :

Original Hashed File

Key field Field1
1 aaa
2 bbb
3 ccc

Rows to update :

1 ddd

I am expecting to get :

1 ddd
2 bbb
3 ccc

And I get :

1 ddd
2 NULL
3 NULL

What the problem ?

One possibility is that your hashed file is the driving stream and source is the reference. So any unmatched value results in setting NULL.

You can include a constraint in the update link as IsNotNull(hashDesc).

Post your job design.