How to do Source Database schema changes into all job.

Five Stars

How to do Source Database schema changes into all job.

Scenario
When ERP application Upgrade finished from front end . it also changes backend SQL schema. Our Talend jobs are using this schema as a input /source file.
Q1:  How to propagate schema changes related to data length at target file ?
for Ex:
Customer is 7 digit . it becomes 15 digit now. 
Q2: Need to write ETL Test case after ERP application upgrade ?steps for test case ?
Any help on it would be much appreciated ?
Seventeen Stars

Re: How to do Source Database schema changes into all job.

Usually the length and precision are only be used if Talend has to create tables. Internally these settings has no effect at all. Your job should work without any problems. The only possible problem could be if you are using a schema check component, but if you use here also the metadata schema, everything should be ok.
Nevertheless I recommend always to run test jobs if such figures has been changed.
Five Stars

Re: How to do Source Database schema changes into all job.

Usually the length and precision are only be used if Talend has to create tables. 

First of all thanks for answer ,Here talend is not creating table. For each job we have to create External  and internal table in Greenplum database.

Data flow is :
Read from ERP Application -->Write into HDFS -->Create DDL External and internal table(Manually) --->on component ok ---->tgreenplumrow --->t..Commit.


Do we need to recreate new External and internal table for each test of job ?

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now