Can anyone help me that how can i achieve to generate Data and time and load to Dimension Dim_Date_time Table.
It's depending on the attributes in your date_dim table. Please provide list of attributes in date_dim.
If you want to load the data in date (only date) and datetime (date with timestamp):
Define this code in tMap OutputColumn field --> TalendDate.getCurrentDate()
and then, define any of below format in schema of tMap Out:
"dd-MM-yyyy HH:mm:ss" for date with timestamp,
"dd-MM-yyyy" for date,
" HH:mm:ss" for timestamp
For parsing the date (if required), use TalendDate.parseDate function.
Please attached mapping for it.
I have attached a referenced code for tMap, please have a look and let me know if it helps.
Please find new attachment.
I am passing the exact code written in VAR area.... Please check the "out_log" date format in below of the screen.
Yes exactly what i want.. Thank you @vboppudi
Can you please show me component detail so that i am also load date and time in dimension table.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.