Having trouble using Dimention Update Lookup step for ETL.
Problem is the Date Range Start field and Date End fields.
Lets say I have a Customer dimention that has two date columns
Date Created and Date Deleted.
Now lets say I want to answer the questions:
How long has "XYZ" been our customer?
Is "XYZ" a valid / active customer?
Using Dimension Lookup Update, is there any way I can
answer both these questions using the two date columns mentioned above.
In other words can I use the date columns from Table Input to populate these fields.