DSXchange

2. Check this variable in your oracle stage. It is appended the value

Check environment variable in QA. You will see the difference.

This warning means you have duplicate keys in the lookup data. Just run the same query with goup by the keys and cout, you found some keys with more than one count.

Sorry, I won't see this is a Server Job.

ID NAME 1 XX 1 YY 1 XY 2 SS 2 DD 2 PP I WANT OUT PUT AS -----------> ID NAME 1 XX#YY#XY 2 SS#DD#PP ================================= transformer : 1. Define three stage variable ===> stgCount number intial value 0 ===> stgApndVal vachar (...) initial value '~~~~~~~~~' ===> stgKey 2. Derivation ===> ...

Define same table in the temporary as your target withh all indexes and constaints on. Try oracle stage to upsert the data into this table . From director log you will found how many rows got inserted and how many rejected or update.

Handle deleted records separately not with CDC.

We did it using custom build stage (or you can try by buildop stage). I don't think anything available in data stage for dynamic file generator.

Separate them by using Transformer and create file accordingly.

"Multiple Rewcord Type" is dyanamic or fixed?

1. Double click in your lookup stage.
2. Click on "Constraints" button (Second left from top-left corner)
3. Select your link from the list of "Multiple rows returned from link"

lookup stage --> link tab

Select "Multiple rows returned from link".

99.99 + 99.99 = 199.98

What else do you expect? Did you any warning when you run your job?

Make the column as double with no length and scale.