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