Updating tables

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ScottDun
Participant
Posts: 61
Joined: Thu Dec 10, 2015 9:51 am

Updating tables

Post by ScottDun »

Hi All,

I am working with 2 tables to update 1 of them. I have my Address table and Key table. They both have common columns named CLient ID and ODS_ClientID. The Key table populates ODS_ClientIds and I want to update them in the address table. So for every client id in the address table, there is a ods client id. the ods client id is the same for each client id. so if i have 4 client ids of 11111111, their ods clients will be 1520148752 (FOR EXAMPLE). So again, each client id has its own ods client id, that is generated from the master table, and I want to simply update the address table's client ids to populate their ods client ids.

Any help would be tremendous.
SCOTTDun
Post Reply