Four Stars

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

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

10 REPLIES
Nine Stars

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

Hi,

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

 

Regards,

 

 

Veeru Boppudi
Four Stars

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

Hi Verru,

 

Here are attributes of Dim_date_time:

Attributes.PNG

Thanks,

Arpit

Six Stars

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

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.


Regards,
Mohit
Four Stars

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

But Its not populate any date data in dim table.

Six Stars

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

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


Regards,
Mohit
Four Stars

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

datee.PNG

Six Stars

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

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.


Regards,
Mohit
Nine Stars

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

Hi Arpita,

 

Are you looking for this data?

 

DateDim.PNG

Regards,

 

Veeru Boppudi
Four Stars

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

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

Nine Stars

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

Please find the tMap configurations below.

 

DateDim1.PNG

Regards,

 

Veeru Boppudi