Hi experts,
I have the requirement to populate the filename into a target table column in odi 11g.
We have folder and the external process creates a file in that folder and we have to get the file name into the target table column while loading the file to a table.
I cannot pass the file name at runtime into a scenario as the file name changes every day.
Please help me to implement this. Any work around is also fine.
Thanks.