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

Six 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

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
Six 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
Six 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
Six 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
Six 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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.