Skip to Content
0
Jan 09, 2023 at 02:22 PM

DWC : Read date related information from Flat file

115 Views

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.

file-date.png

Attachments

file-date.png (16.9 kB)