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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema