ETL job with Talend Open Studio for Data Integration. We will create a basic date dimension which you can then extend even further. In order to follow this tutorial, the reader should be familiar with the basic functionality of Talend Open Studio.
Date_Key
Day_Text
Day_Of_Week_in_Month
Day_in_Month
Day_in_year
Week1
Month_No
Month_Name
Quarter
Full_year
Current_Date
Job Design:-
First
trow generator ---> Create Filed ---->
Date ---> Type filed Date
Trowgenarator ----->tmap---> Database Output Component
Out Put:-
No comments:
Post a Comment