Insert/Update Table
Posted: Thu Jun 02, 2005 12:34 pm
Hello Sirs,
I have master customer file and 4 ODBC Dataware house tables like cust_address,country,region,geography tables.
I have to Insert all records into cust_address table where no customer key and customer addrtype = 's' not found in cust_address table when matched with master customer file using custno key field.
I have to update cust_address table when current record is differ from existing master record based on fields
geography key,address1,address2,postal code,phone number...
Can you suggest me how to create the job.
Thanks
Narasa
I have master customer file and 4 ODBC Dataware house tables like cust_address,country,region,geography tables.
I have to Insert all records into cust_address table where no customer key and customer addrtype = 's' not found in cust_address table when matched with master customer file using custno key field.
I have to update cust_address table when current record is differ from existing master record based on fields
geography key,address1,address2,postal code,phone number...
Can you suggest me how to create the job.
Thanks
Narasa