Error message during reference match stage

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
shaonli
Participant
Posts: 80
Joined: Tue Nov 28, 2006 6:52 am

Error message during reference match stage

Post by shaonli »

I m trying to run the Ds job through Reference_MAtch stage .
i have to compare two columns(data and reference) and get the percentage of match for all the records.
But i am receiving as FATAl ERROr as "main_program: Fatal Error: Field not found: keyChange"

Can anyone suggest on this .
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

See answer to your other post. A column called keyChange is usually the result of a Sort stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
shaonli
Participant
Posts: 80
Joined: Tue Nov 28, 2006 6:52 am

Post by shaonli »

I have taken two column from two seprate files to compare through reference match stage.

I have used CHAr comparision with m prob as 0.66 and u prob as 0.33
I have only one column in both the files and i have not used the block command.

What is parameter which need to be defined
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You must have at least one blocking field. Even if it's a constant in each file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
shaonli
Participant
Posts: 80
Joined: Tue Nov 28, 2006 6:52 am

Post by shaonli »

Do i need to give Weight Override, and Cut off values
Post Reply