Date Generation Transformation:

This transform will help us to create the dates incremented as our requirement.

When we use: To create Time Dimension fields and Table


Create a new PROJECT and a JOB as shown in below screen.


Bring the Date_Generation Transform into Data flow.


Set the options as shown below.

1.JPG

Start Date : 2000.01.01

End Date : 2100.12.31

Increment: Daly

Bring the Query_Transform and map the columns as shown.

2.Date_Functions.jpg

Map the columns as shown below:

DATE:Date_Generation.DI_GENERATED_DATE

WEEK: week_in_year(DI_GENERATED_DATE)

MONTH:month(DI_GENERATED_DATE)

QUARTER: quarter(Date_Generation.DI_GENERATED_DATE )

YEAR: year(DI_GENERATED_DATE)

2.Date_Functions.jpg

3.JPG

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply