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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Move from On-Premises to the Cloud by following the advice of experts
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries