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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog