QS match Jobs takes more time to run

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
senthilmp
Participant
Posts: 85
Joined: Mon Sep 22, 2008 6:11 am

QS match Jobs takes more time to run

Post by senthilmp »

Hi,

I have created a match job to compare the address information and blocked on the Country field. Both the input file has country fields.

File A has around 79K records and File B has around 30k records, the job is taking more time to run.

Can anyone help me out to decrease the time taken? Or should i use different way of blocking?

I have just made a direct Country Blocking and comparing on three fields only. Pls advice.

Thanks,
senthil
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

More? More than what? Why do you think that the time is not acceptable?

Faster hardware may help. More memory may help. Sorted data may help.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
senthilmp
Participant
Posts: 85
Joined: Mon Sep 22, 2008 6:11 am

Post by senthilmp »

More means it takes greater then 6 hrs, and Ok i am now going to try out with Sorting the data based on country as you suggested.
Post Reply