Tables

Table 1 :Contenu de la table Prod_log après le premier batch de modifications

lsn	log_date	tran_type	productid	productname	package	namechg	packagechg
1	2002-12-02 13:50:47.553	I	101	prod1	10	NULL	NULL
2	2002-12-02 13:50:47.627	I	102	prod2	10	NULL	NULL
3	2002-12-02 13:50:47.627	I	103	prod3	10	NULL	NULL
4	2002-12-02 13:52:41.640	U	103	prod3	20	0	1
5	2002-12-02 13:52:41.980	D	102	prod2	10	NULL	NULL

Table 2 : Information sur l’onglet Queries de Type1 Refresh DDQ Task Properties

Query Type	Query	Destination	Parameter
Insert	INSERT INTO Products_type1 (productid_app, productname, package) VALUES(?, ?, ?)	productid_app productname package	1 2 3
Update	UPDATE Products_type1 SET productname = ?, package = ? WHERE productid_app = ?	productname package productid_app	1 2 3
Delete	UPDATE Products_type1 SET discontinued = 1 WHERE productid_app = ?	productid_app	1