Skip to Content
0

Transformation issue

Jun 07, 2017 at 03:44 PM

38

avatar image

Hi experts,

I have a DSO2 with 5 fields ( F1,F2,F3,F4 and F5) , the source data of theses fields is the DSO1. I would like to create another DSO3 that contains F1, F2 and F3 create a transformation to transfert updated data into DSO2.

hence there will be to transformation into DSO2 , (F1 and F2 are the key in this DSO)

My issue , how can I load data from DSO 3 in order to modify F3 for F1 and F2 without impact data related of the remaining fields (F4 and F5)?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mario Tibollo Jun 08, 2017 at 06:10 AM
0

when loading data from dso1 to dso2 read field F3 from DSO3 in transformation start routine

Share
10 |10000 characters needed characters left characters exceeded
crossmen crossmen Jun 08, 2017 at 11:13 AM
0

Hi,

the load type between DSO1 and DSO2 is delta, so some times there is data in DSO3 (F1,F2 and F3) not contains in in the delta load between DSO1 and DSO2.the aim is to modify F3 from DSO3 without impact other fields F4 and F5 in DSO2 althout data of F2 and F2 don't exist in load data between DSO1 and DSO2.

Thank you.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

if you don't have the complete key from dso3 you will overwrite all records with the same value for F2. what is the exact key from dso3? and perhaps illustrate with an example

0