Job can only execute one match stage

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

Job can only execute one match stage

Post by ewartpm »

:? Does anyone know how to create a job that executes more than one match stage. I currently have 4 different match stages and want to automate this.

Many thanks
Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Post by timwalsh »

Put 4 different QualityStage (INTEGRITY) Stage's in a DataStage job. Call each one of your match procedures in the order you want. Then connect them together.

You might have to put flat file buffers between them.

Source => Match 1 => Match 2 => Match 3 => Match 4 => Target

Or

Source => Match 1 => Flat File => Match 2 => Flat File => ....... Target

Is this what you were asking about?

Tim
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

QualityStage Match Procedures

Post by ewartpm »

timwalsh wrote:Put 4 different QualityStage (INTEGRITY) Stage's in a DataStage job. Call each one of your match procedures in the order you want. Then connect them together.

You might have to put flat file buffers between them.

Source => Match 1 => Match 2 => Match 3 => Match 4 => Target

Or

Source => Match 1 => Flat File => Match 2 => Flat File => ....... Target

Is this what you were asking about?

Tim
I'm not sure what you mean. I have a QualityStage job with 4 match procedures in the job. When I try to run it I get a message along the lines of 'more than one match stage' and the job does not run. There has to be a way to automate this. Basically, from what I can see, you end up putting all the stages into one job or is there something I'm missing?
Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Post by timwalsh »

Yes,

You have multiple QualityStage stages in one DataStage job, calling a single procedure within each QualityStage stage.

Wow that sounds confusing. Did you comprehend?

Tim
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Post by Teej »

Ouch! That hurts...

-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
PilotBaha
Premium Member
Premium Member
Posts: 202
Joined: Mon Jan 12, 2004 8:05 pm

Post by PilotBaha »

Ewartpm,
you cannot run more than one macth stage in a single job. This has been the case since the earlier versions and I think it is still an issue in the latest ver. 7

If you are using an ETL tool with QS, like DataStage or Informatica, then you can have the ETL tool call your 4 different jobs in sequence. This will take care of the automation, even if it is not within QualityStage.
Post Reply