Hi all
I am working on data integration wherein, I'll be consuming lot of business flat files into DWC. As part of that, I need to achieve a specific thing i.e., to read the file name from the flat files that are posted on daily basis & pick up the date value & fill it in the column for ex. "FILE_DATE" that we create in DWC.
I wanted to read the file name and get the '01/01/2023' & keep the value as constant in that column : FILE_DATE associated with that day's data load refresh.
Similarly with all.
Please let me know, if this is achievable.
