Hello experts,
I have loading metadata without problems, my file have parent column, memberid, etc.. but sometimes parent ID is wrong (not exists in PBCS) in this case I have a folder in dimension called "Pending Assigned".
is there any way to validate if a parent exists in dimensions before load and if not exists load in Pending Assigned? Maybe in mapping section?
Any help will be appreciated.
Regards