Best Practice for insert and updates

[Anonymous]

I have good solution for insert and updates. 
(With this solution you can perform inserts and updates very very quickly)
When you are  getting records from the source from any data base, use tmap after any inputDb and do look up with the target , and use inner join lookup model with the cloumn to be matched, Then whatever it matches with key store all records in Temp table, Create table in the job run time.The other new which does not match with the key will go to direct insert. 
Than using Merge concept sync temp table and target 
After that delete temp table at the end
Example of Merge query (By using this merge query it will sync source and target with in seconds)

MERGE Table A AS TARGET
USING Table B AS SOURCE
ON TARGET.tableacol1= SOURCE.col1
WHEN MATCHED
THEN
UPDATE
SET

TARGET.col2= SOURCE.col2,
TARGET.col3=SOURCE.col3;

[Vinisha]

yes it worked, it improved the speed of the job , rather using insert/update inbuilt, its better to use, when we have Million  of records

[vapukov]

---

@Vinisha wrote:

yes it worked, it improved the speed of the job , rather using insert/update inbuilt, its better to use, when we have Million  of records

---

and it kill your Talend server when you have 100 millions and what you will do when you have a billion?

[Anonymous]

Hi,

Can you please explain in more details.

Thanks,