tablediff - incremental load data changes

Question

Post reply

tablediff - incremental load data changes

Balaji L

Hall of Fame

Points: 3067
More actions
May 11, 2009 at 3:00 am

#129874

Hi ,
How should I use tablediff for incremental load data changes. I think this is good for comparing source and destination data as table. If source data comes from files like xml,csv,txt in that how should I use tablediff for incremental load data checks.
My manager proposed to use this tool for incremental load checks. Can you please tell me the pros and cons of this tool?
Any help would be really appreciated.
Thanks,
Balaji L

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Balaji L Hall of Fame Points: 3067 More actions · Answer 1

Hi, can anyone help me out of this?

Thanks,

Balaji L

malli.msbi SSC Rookie Points: 36 More actions · Answer 2

Hi Balaji,

from ssis Tools u will be process the incremental load using scd Transformation..

Regards,

Mallik.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

I got this off a simple Google search...

http://weblogs.sqlteam.com/mladenp/archive/2007/03/03/60125.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)