DSXchange

Seemed more like you were saying why would I post the answer. Anyway, let us know what you find out. Failing that, let us know the stage you are using, something you still haven't mentioned.

In your shoes, I would involve my DBA and have them trace the activity, confirm that the index is indeed being used and your table is not being "full table scanned" for each update.

In other words, just like you thought.

There is no "restartability" out of the box, that's something you need to design into your jobs based on your job's architecture and requirements.

What makes you think the Merge stage can't do a full outer join? From what I recall, you would use what it calls a "Complete Set" as the Join Type, have you tried that?

Does it provides the same functionality for the SQL Server too or provides different functionality as my target database is SQLServer. And if it provides different functionality then "Clear table then insert rows" for the update action in SQL Server is going to delete all the rows or drop...

I dont have any documentation I find that very hard to believe. There is the "online" help text available from any of the client tools, plus an entire directory of pdf documentation at your disposal. Not to mention the Help button that is in each and every stage. You really should check t...

Neither one "drops" the table. And you have the documentation, I don't, so why not simply look it up and tell us?

As noted in the documentation, those two Update Actions perform two different functions in Oracle. They only behave "the same" for DB2 and Informix.

Not sure what the heck that is supposed to mean, but if you are having an issue - start a new post.

Read what was posted a little more carefully.

Same tool. From what I recall you need to enable manual selection and then only push over the category that you want.

What stage are you using? Most would have an update action similiar to "Clear table then insert rows" which would do the truncate for you.

New question = new post, please. That or search for some of those key words as it has been discussed here a number of times.

Same way. The registry key can't be all *that* different for 8.x so simply search for "dsdesign" and see where it turns up.