My input data is in csv file with sales records. I am using look up transformation to check those records if the record in fact table match or not by store_id and Date. However, I got issue with date column. I want to confirm if I am doing
it right or wrong.
Flat File Columns
I am using data conversion transformation to change data to (DT_DATE), after the transformation here is the data.