overwrite problem on company code text from multiple source systems

[former_member773891]

Dear Experts,

Currently we had characteristic 0COMP_CODE which have short text and middle text. ( e.g. CC1, beijing, beijing middle text)

0COMP_CODE's middle text should extract from ECC

0COMP_CODE's Short text should extract from outside flat file.

Currently two loading had conflict, for example, after we load middle text from ECC, all short text had deleted as blank. in reverse way, after short text loaded, middle text get deleted.

any good solution for this problem ? thanks in advance

Regards

Jie

[Former Member · Accepted solution]

Hi,

You need to have one middle layer for this.

You may stage text from file in a DSO or infoobject then while loading text from ECC you may do lookup on existing staged text from file record by record.

You may have full load everyday. First load the staging object from file and then load text from ECC in Compnay code info object.

I hope this will satisfy your need.

S

[Former Member]

Hi,

you should use 2 infosources, one for the ecc datasource and one for the flat file datasource. Create transformations from these infosources to your object and update only the desired fields.

Siggi

[mansi_dandavate]

while loading short text, you should keep middle text as no update in the update rules/transformations.

And while loading medium text, you should keep short text as no update

Regards,

MD

[former_member773891]

In transformation, I had set rule type as " NO Transformation", but it still write blank value to characteristic text.

[Former Member]

Hi ,

You can try loading all the required data to DSO first , and then to the mater data IO