DSXchange

Without the loop, could you not set up individual output links for each column and constraints to control them? Then a Funnel to put them back together.

Best to take this to support, IMHO.

So the NULL in your incoming record indicates "no change" for that field?

And it's still a Type 2.

ShaneMuir wrote:You might also consider looking at the SCD stage (this looks like a Type2)

Yup.

I was going to suggest... PL/SQL.

Interesting... thanks for checking. Seems to me that DataStage must be supplying the wrapper quotes otherwise Oracle would be barfing.

Support.

Meaning, without knowing what it currently is?

Is this actually a Server job question as marked? You'll need the SKU_ID enclosed by percent signs and single quotes for the LIKE operator, so probably more like this. Have no way to test it, however. UPDATE SKU SET SECONDARY_DESC=:SECONDARY_DESC,COLOR=:COLOR WHERE SKU_ID LIKE '''%'||:SKU_ID||'%'''

Then perhaps permissions?

For a NullPointerException? Support, I would imagine.

That would have been quicker to just test out for yourself.

Interesting. That or go all Old School on it and just demote the thing.

Aye Matey!

☠

Awesome, thanks Franklin.