Regarding multiple DSO to single DSO

[Former Member]

I have loaded data to 2 dso's., In one DSO1 i have Cust num, Cust age and in another DSO2 i have Cust num, Cust address, Cust contact #., From these two DSO1, DSO2 have to load to DSO3 of final one on the top of the two DSO'S.

Whats the Procedure like how loading happens to Final DSO., Whether have to map anything at DTP'S.

Because at FInal output of DSO3, i need a single record of Cust num, Cust age, Cust address, Cust contact #.

Can anyone help me or guide me out.

Thanks in advance.

[Former Member]

Hi,

Use smae key fields in the DSO3 , if same data is coming from 2 DSO's then use the start routine and update routine for that key fileds.If same data is not coming then, use directly create transformations , data will differentiates with out writing routines.

Cheers,

Ramesh..

[Former Member]

Hi,

You can use same key fileds in the DSO3 . It will directly pick from the DSO1,DSO2, because different customers data come from different DSO'S

[Former Member]

in order to get single record in 3rd DSO you need to make sure that all 3 DSOs have same Key..

otherwise you can load data from DSO1 to DSO3 and in start routine of this transformaton select data of DSO2 based on source_package of DSO3 and map the values of DSO2 in some internal table... and in characteristic routin refer this internal table and fill 'Cust num, Cust address, Cust contact #' values in DSO3

Regards,

Sharayu

[Former Member]

Hi

In order to get single record in DSO3 you should have cust num as key field remaining fields are in data fileds, then creatd 2 transformations for dso1 and dso2 to dso3.

let me know in case any issues.

Regards

YuvaraajP

[former_member360228]

Hi,

In DSO 1 and DSO 2 what are your key-fields?

You can try by having Cust Num as your key-field in DSO 3 and create two transformations from both the DSO's to DSO3. It depends on your choice of key-fields whether you'll get the data in single line or not.

Another option is to have one transformation from DSO2 to DSO3 and in that transformation do a lookup on the DSO1 fields.

Let me know in case of any issues.

Regards,

Arminder Singh