insert and update data

[mayura]

condition
table contain data

Target
want to insert the records(may be old or new)
and update all the records present in target.

solution:
currently i am using the DRS stage here in before query i used update statement means before inserting into table it will update the all data in table with indicatior as N and then insert the fresh data into table.
But while running through DRS stage i amnot able to load the data.link shows data has been loaded but table is blank,,
Please let me know how to use exact update and insert using DRS stage.

Thanks,
Mayura

[ray.wurlod]

The row count on the link shows how many rows were sent to the database server, not necessarily how many rows were loaded.

Are there any errors/warnings reported?

Show us exactly what you're doing in the DRS stage, it's usually easier to spot errors than to regurgitate the manual.

[mayura]

The row count on the link shows how many rows were sent to the database server, not necessarily how many rows were loaded.

Are there any errors/warnings reported?

Show us exactly what you're doi ...

warnings comes as literal string does not match with format specified and link shows around 40k records but o in target and throws above waring.

[chulett]

in before query i used update statement

So... you update everything with a blanket update sql in the "before SQL" section?

You need to post your actual (unedited) errors before anyone could really help, that and detail all of the settings you are using in the DRS stage. Without that, we'd all be... guessing.