I am using TOS. I need to load the data into another DB when an error occurs in the first DB, the total data has to be loaded into another DB while error. I tried using on component error load data into another db.But I failed in doing on component error.
input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2.where am stepping wrong.
Any other approach would be appreciated and helpful to me.
Thanks in advance.
@kolen,you need to take the reject data from the first table means you need to follow the below way.
Thanks for the Quick reply.
No sir. if DB fails in loading... the complete data has to load into another db.this is not about the rejected records.
if DB fails in any cause. the job should not terminate, instead, it should load into another db.
Yes, am getting an error.
like I took one "id" which is primary and passing null values which are throwing errors..but the job is getting exit. instead, it should flow to another job.
any idea! please suggest.
@kolen,on which component you are getting error?
Thank you for the idea.
can u please elaborate. the scenario to get the DB error.so that the flow should go to the 2nd DB
my req. is, if one DB is down at the time of insertion the flow of insertion at the particular record the insertion of that record should go to the other DB.with out fail.
Can u please suggest any idea...
Thanks in advance.
@kolen,you can implement in below way.
But I already applied this approach...but here again, the input has to read and load into another db.
But my req is not like that, while insertion if server down at particular record the records should insert into another DB.ie...while insertion if a server is down in db1 the rows should continue in inserting in db2...if server is up it should continue in db1 like that...the job should not stop till all rows got inserted.
@kolen,try this way.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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