Page 1 of 1

Need advice on DataStage QualityStage interaction.

Posted: Wed Oct 15, 2003 6:32 pm
by vmcburney
I'm using the QualityStage plugin for DataStage. I need to take a flat file with about 100 fields and no primary key, clean six of the fields in QualityStage then write the result out to a new flat file with the same 100 columns. What is the best way to do this? If I pass just the six columns to QualityStage how do I merge them back into the 100 column format? If I pass all 100 columns to QualityStage doesn't this slow the job down and create a metadata management nightmare? While DataStage can import table definitions in a matter of seconds QualityStage users need to do it manually and are restricted to short column names.

There are several different file formats but the objective is the same, to clean the same six fields from each file.

Posted: Thu Oct 16, 2003 5:30 pm
by vmcburney
Well we came up with a design for anyone interested.
Allocate each row a unique identifier. Pass a few fields and the unique identifier to a QualityStage stage and output the clean values to a hash file. Read the original file in and replace the old fields with clean fields from the hash file using the unique identifier as the key field.

Posted: Fri Oct 17, 2003 7:50 pm
by ray.wurlod
This isn't a bad idea - it's part of "best practice" for the INTEGRITY product to maintain a cross-reference file containing a (generated) unique key to rows in source data.

Interaction between DS(PX)7.x , QS?

Posted: Tue Nov 11, 2003 3:56 pm
by vdreddy
Can you advice on how ur doing interaction between DS and QS stages?
1. R u using QS as a stage in the DS?
2. Is there a seperate plugin for using QS in DS?

Your feedback is appreciated.

Posted: Tue Nov 11, 2003 5:09 pm
by vmcburney
We are using the QualityStage plugin for DataStage. DataStage opens a sequential file containing addresses and passes those address fields to QualityStage, it cleans them and maps them to Australian AMAS address standards and passes this address format back, DataStage then writes it out to a sequential file.

The controlling sequence job then calls up an additional QualityStage job by shelling out to a Unix script and executing it from the command line, this job produces match reports on the address file created by the embedded QualityStage job. This is for reporting purposes and was easier then embedding it in DataStage.

In transactional mode the QualityStage plugin operates just like a transformer with rows passing through it.

Posted: Tue Nov 18, 2003 2:48 pm
by vdr123
Thanks for the feedback...

Do you know if we can use QS plugin for PX jobs...when i tried to add the QS plugin in the PX-job pallette...it shows them on the pallette...BUT THEY ARE DISABLED...

When i open the server-job, i can see them enabled there...

Is the plugin for only DS...is the plugin not compatible with PX jobs???