DSXchange

I want to drop all index to improve loading proceses,But i have to upsert medhod because primary key of table is increasing by trigger automatically.
oracle target stage hasnt open/close command.
how can i drop index before ınserting and create after inserting.

Hi,
I use write medhod UPSERT with upsert mode Update and Insert,but performance is very bad.When i use Insert and Update mode,performance is very very good but data is doubled if the data is already loaded before.
How can i solve this?

thanks for your helping
but how can i detect the change in previous row to the current row in transformer

Hi, I am junior developer and have problem.I have source data like above.Credit_id is increasing automatically credit_id proposal_id 1 1 2 1 3 1 4 2 5 2 and i want to put this data to target like this credit_id proposal_id credit_index 1 1 1 2 1 2 3 1 3 4 2 1 5 2 2 how can i do? thanks for your helps