How to generate date and time and load to Dimension Date_Time table.

[Anonymous]

Hi All,

Can anyone help me that how can i achieve to generate Data and time and load to Dimension Dim_Date_time Table.

Thanks,

Arpit

[vboppudi]

Hi,

It's depending on the attributes in your date_dim table. Please provide list of attributes in date_dim.

Regards,

[Anonymous]

Hi Verru,

Here are attributes of Dim_date_time:

Thanks,

Arpit

[mks02]

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.

[Anonymous]

But Its not populate any date data in dim table.

[mks02]

Please attached mapping for it.
I have attached a referenced code for tMap, please have a look and let me know if it helps.

TLND_Date.PNG

[Anonymous]

[mks02]

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.

TLND_Date_2.PNG

[vboppudi]

Hi Arpita,

Are you looking for this data?

Regards,

[Anonymous]

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.

Thanks,

Arpit