Skip to Content
0
Former Member
Jan 21, 2011 at 03:45 AM

DSO Record Modify

51 Views

Hi

I am given an option of my raw data either in 2 options. The update is from datasource to a DSO.

First option: i have 2 datasource. Each data source has the same key, but contains different information.

Second option: i have 1 datasource. The 2 different information will be merged in 2 datasource.

The aim is to build a record containing 2 different information in a dso.

Key1 Field1 Field2

ABC 123 456

Example First:

Datasource DS1

Key1 Field1

ABC 123

Datasource DS2

Key1 Field2

ABC 456

My problem is when i load DS1 then DS2, the record reveals as:

Key1 Field1 Field2

ABC Blank 456

Example Second:

Key1 SOURCE Field

ABC DS1 123

ABC DS2 456

When i try to do the load, the second record overwrite blank for Field1.

Key1 Field1 Field2

ABC Blank 456