How to merge data from two databases with same schema using looping?

[Jedi-Habs]

Hi,

I have a situation where there will be two PROD databases running in parallel for some time before the old version is decommissioned. Warehouses will be gradually moved over from one database in to another but at a time, a warehouse will be connecting to only to one database. So till all the warehouses are moved from the old to the new data base we will have both of them running in parallel. Both these data bases have the same schema but different passwords.

I have a .csv file which has the db information as shown below. The "Y" s at the end indicate which password it has to pick from the context file

RP_DRP_AdditionalParams|RP_DRP_Port|RP_DRP_Schema|RP_DRP_Server|RP_DRP_Database|RP_DRP_Password1|RP_DRP_Password2

|1433|talend|tstddrpDB01|FWD|Y|

|1433|talend|tstdrpSQL1|FWD||Y

My context file is specified as below.

My looping mechanism for two databases is a joblet designed as below.

But when I run a job with the joblet in it, I am getting the following errors.

Any ideas how I can get this resolved? Thanks.

Habs

[JohnRMK]

You forget a ; in the else if condition

[Jedi-Habs]

Thanks John. After positing the issue here, I was able to get this resolved. First the whole 'if' clause needs to be in brackets it seems. Second, the entries in "read_cred" (main) were wrong. Once I fixed these two, it worked. Thanks for your input anyways.