Data frm SERVER doesnt match with Parallel in Change Capture
Posted: Wed Feb 28, 2007 10:37 am
Hi,
I have a server job which I exactly replicated as a parallel job to make the process run faster. I am trying to compare the files from both jobs (Server and Parallel) with change capture stage to make sure the old process data matches with the new process data.
The SERVER job output is a FIXED WIDTH file and the parallel job output is a default SEQUENTIAL FILE.
I am trying to compare these file and have specified all the values as "keys" along with "Explicit keys and Values" option. I have specified the partition type as "HASH" in the change capture stage and selected all the keys in the same order they were mentioned in "CHANGE KEYS" option.
But when I run the job some of the data does not match, i took some columns that are hard coded in both the jobs as keys, these columns dont match when I also specify them as keys to partition the data. When i do not specify them as keys for partitioning they match perfectly.
Can I specify all the "keys" as "keys for partitioning" also ?. Is there another reason why the comparision wont work?
Please help me out. thanks
I have a server job which I exactly replicated as a parallel job to make the process run faster. I am trying to compare the files from both jobs (Server and Parallel) with change capture stage to make sure the old process data matches with the new process data.
The SERVER job output is a FIXED WIDTH file and the parallel job output is a default SEQUENTIAL FILE.
I am trying to compare these file and have specified all the values as "keys" along with "Explicit keys and Values" option. I have specified the partition type as "HASH" in the change capture stage and selected all the keys in the same order they were mentioned in "CHANGE KEYS" option.
But when I run the job some of the data does not match, i took some columns that are hard coded in both the jobs as keys, these columns dont match when I also specify them as keys to partition the data. When i do not specify them as keys for partitioning they match perfectly.
Can I specify all the "keys" as "keys for partitioning" also ?. Is there another reason why the comparision wont work?
Please help me out. thanks