i have a birth_date column '1962-02-19 00:00:00' "yyyy-MM-dd" format
i want to split birthday-month-year and load it to three different database table.
please help me out
Thanks & regards
You could use tExtractRegexFields to split your input data into three parts.
Something like this -
And have your regular expression defined as -
and the schema as -
Once you have done with your data split then you could have your database output defined accordingly.
@vitspltalend,please find below tMap configuration,you can implement in this way also.
you can convert belo way also.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend