Flat File Vs ECC load

[former_member627490]

Hi,

We have an IO XXX (char 3) which is master data with attributes loading from Flat file. Now for this IO few of the attributes should be derived from ECC Z table with routines/some other logic.

There is a 4 char lenghth field in the Z table with the first 3 characters as the IO value. Can any one let me know how to achieve this.... These two attributes are tme depandant values and

I need to use the From and To dates available from ECC Z table to update these values ....

Example: XXX has 333 Z table has 333A with other attributes info.

I created a DS using the above Z table and derived the XXX value and brought all other fields in to an ODS, Now I'm loading this ODS first then the IO XXX, so that I can read this ODS table in UR

to get the two attribute values dynamically...Please let me know if this is correct or if there ia any other solition for this req....Thanks

[former_member183777 · Accepted solution]

You could load the IOBJ directly from the z-table datasource, doing reqired conversions in the transformation / transfer rules. If you need the z-table in an ODS for other needs, then your stated approach work as well.