FDMEE data load from two sources
Hello Team,
We are working with a customer, where we need to load data in FDMEE from multiple sources at once.
Sources are: Flat File and SQL tables
Target is : Custom application (file based target)
We are using BefImport event script. The BefImport event script will copy all the records from Source1 (select file in data load rule) to temporary file (AOI_HFM_temp.txt), and also appends Source2 (SQL tables data) into same temporary file.
Our intention is, FDMEE should use the temporary file as the source file while import data.
To obtain this we are updating aif_bal_rule_loads