Date Generation transform
This is ultimate transform for creating Time dimension tables.
It generates dates incremented as you specify.
It generates dates incremented as you specify.
Options:
--> Start date : Well DI document says that start date range starts from 1900.01.01,
--> End date: The date range ends with 9999.12.31.
Instead of selecting values we can pass variables also.
--> Increment: We can specify date intervals between the sequences.
We can increment daily, weekly and monthly.
--> Join rank: While constructing the join, sources will be joined based on their ranks.
--> Cache: The data set will be cached in memory to be used in later transforms.
--> Start date : Well DI document says that start date range starts from 1900.01.01,
--> End date: The date range ends with 9999.12.31.
Instead of selecting values we can pass variables also.
--> Increment: We can specify date intervals between the sequences.
We can increment daily, weekly and monthly.
--> Join rank: While constructing the join, sources will be joined based on their ranks.
--> Cache: The data set will be cached in memory to be used in later transforms.
--> Demo:Drag the date_generation transform from the object library on to the work space, and in
the next step connect a query transform and next step is your target object.
Your design would be like this
Now open the date_generation transform and mention values, check the image for reference
Now you’re done with the design part, save it and execute it. View the data
