Key and PK columns
Posted: Fri Jan 03, 2014 12:40 pm
Hi,
Have 1 doubt, can anyone please clarify.
Suppose I have 5 columns A,B,C,D,E.
I got 2 jobs
Job 1. SQL Server -> Copy -> DataSet
Job 2. DataSet -> Column_Generator -> Oracle.
A,B are PK columns in source(SQL Server) and column A is Pk column in Target Table(Oracle).
In the copy stage, done Hash partition by A,B and in the DataSet, partition is SAME.
In the second also in Column Generator and in Oracle stage, partition is SAME.
In the Oracle stage, I have used Update then Insert, Where clause for Update I have used
WHERE (B = ORCHESTRATE.B)
We are in the grid environment, I have run couple of times, count is getting match between source and target.
Question: Is the approach correct or any changes has to be made.
Thank You,
Have 1 doubt, can anyone please clarify.
Suppose I have 5 columns A,B,C,D,E.
I got 2 jobs
Job 1. SQL Server -> Copy -> DataSet
Job 2. DataSet -> Column_Generator -> Oracle.
A,B are PK columns in source(SQL Server) and column A is Pk column in Target Table(Oracle).
In the copy stage, done Hash partition by A,B and in the DataSet, partition is SAME.
In the second also in Column Generator and in Oracle stage, partition is SAME.
In the Oracle stage, I have used Update then Insert, Where clause for Update I have used
WHERE (B = ORCHESTRATE.B)
We are in the grid environment, I have run couple of times, count is getting match between source and target.
Question: Is the approach correct or any changes has to be made.
Thank You,