Loading data in to another db while on first db error

[Anonymous]

Hi Team,

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.

[manodwhb]

@kolen,you can implement in below way.

input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2

[Anonymous]

Thank you!

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.

[manodwhb]

@kolen,try this way.

input-->tmap->outputdb--->rejects-->outputdb2