Skip to Content

Transformation issue

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)?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 08, 2017 at 06:10 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 11:13 AM

    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.

    Add comment
    10|10000 characters needed 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