Hi,
i am trying to load multiple files into single interface/. data loaded sucessfully. 92. files are there. for this i have used variables & package.
my requrement is, 92 files of data loaded into target table. i want to know which data coming from which file.
for this i have added one column (filename) to existing target table.
if i used joins(not equal condition) , its totally wrong. all file names are coming.
please see the following screen shots.
output ; target table.
actually in this target table. first 10 rows are coming from first file.i.e _ACCOUNT_LIMIT_511.TXT. but all files names are coming.
i am getting confused,. after first file data inserted then second file data will insert. in this all file names are coming. please help me.
i thought global variable is better to identify data is coming from which file.
for this , global variable is used in target table. still i didnt get my output.
Please help me.
thanks in advance.
