At first glance, NO that't not possible as the Description is always pulled from the Account segment. You might have to dig the complete ODI/FDMEE for changing this.
But random thought did you interchange the Segment 1 || Segment 2 as Segment 2 || Segment 1, can you give a try and see if that helps? But remember it will become 001_1000000.
Dependent segment/sub-account import is not supported via FDMEE/DRM. You can try using ODI but its not simple path.
Can u pls tell us how we can use ODI to get this required output.
This is not supported out of the box.
If you don't want to change anything in the ODI process which is actually not supported, I would suggest you implement a event script (AftImport) to update DESC1 column with SubAccount description.
You could prepare a view in EBS database to get that information.
Hi Francisco Amores,
Thanks for the reply,
I have understood that view means to create one Temporary view table in EBS which contains all SubAccount Description details in this view table.
After data imported from source and populated in to FDMEE, AftImport event script will run which will connects to EBS view table and Updates the DESC1 column for a particular Loadid in FDMEE.
Will you help us with AftImport event script for this update.