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.