oracle update option
Posted: Mon Jul 28, 2008 11:00 am
I have a scenario like the following:
emplid name_type name
12345 PRI John doe
12345 PRI John King
I need to apply same conversion routine to name column, then it becomes like this
emplid name_type name
12345 PRI Kodf urt
12345 PRI Kodf fkgk
emplid and name_type are columns that i am using to update. The data is written to dataset and iam using dataset to update the same oracle table. Now how will the datastage updates the table. Does it updates with two different values or it updates to the same value?
Thanks
emplid name_type name
12345 PRI John doe
12345 PRI John King
I need to apply same conversion routine to name column, then it becomes like this
emplid name_type name
12345 PRI Kodf urt
12345 PRI Kodf fkgk
emplid and name_type are columns that i am using to update. The data is written to dataset and iam using dataset to update the same oracle table. Now how will the datastage updates the table. Does it updates with two different values or it updates to the same value?
Thanks