DSXchange

in the transformer1 try function nulltovalue() for 'Exterior_MXADDR' and give some default value for the null. If the derivation column having null values..transformer wont allow. This may come under datastage problem i guess!! Vairamuthu The job looks like: Seq File1->Transformer1->Standardize->Tra...

Hi, Did you check the both DATA and REFERENCE frequency file ? Regards Hi, I developed Match Sepecification with one blocking field ( ID ) and one Matching field ( Name ). I created Frequency files with that Match Spec. When i ran the Reference Match job, I am getting the below error Reference_Match...

Hi, MatchFrequency file describe how often a value appears in source column. If a name appears 100 times in a column. MatchFrequency file output for that name will be a single row with number of occurance and statistical weight. So 200M records can generate lesser output records. In Matching process...

Hi all, I did column analysis on a table . While reviewing the name column i found some data's are classified as 'NA' format. Only nulls ,spaces and whitespaces will be classified as "NA" format. Example of few data classified as 'NA': Somerset Hospital Nurses Residence Vodacom Container B...

Hi all, i write my unduplicate match and residula results in to a flat file. then i used those flat files as source to write in to the database. am getting warning while writing into the database message:initialday_match,0: Import consumed only 365bytes of the record's 375 bytes (no further warnings...

hi , When you writing output to the sequential file you have to set default null value. if you dont configure this you cant see any records in output file. Eventhough you can see status as success. it will apply to all jobs in datastage/qualitystage... regards Hi All. I have a question regarding Sta...

Hi ankita, The purpose of Ruleset is to parse the input data (standardization) only. The space for standardized data depends up on the number of rules you going to use. Test run with one million and find out the size of dataset file and make it for 150m . Better you can remove the standardization ou...

Hi ,

Open the ruleset and click TEST. It gives you which value is duplicated in the classification table...

hi

While creating the reports you will have option to save a report and format of that report.

you can't save it in a specific location. Reports will be under the saved report section.

After the report is generated in pdf .you can run it and save it to a location.

regards

Thanks Ray

i got only the old redbook..

This new redbook will be help full

Hi guys,

Is there ibm best practice guides available for qualitystage8?

Could you tell me how to access that..

regards
vairamuthu

Hi rupesh, you dont have to free scratch space.. all the temp files neded the jobs are created in scratch space and then the processed data are written to dataset folders in dataset files.then the files in scratch folder are cleared by the sysem once the job is done. So you need to increase the size...

hi aruna,

We are not using Cognos in our project...

Thanks for the info aruna..i will have a look at it

regards
vairamuthu

Hi , 1, How to customize a report in information analyzer .i.e adding a logo etc... 2, when we viewing the column analysis results. it displays like a dashboard with columnname uniqueness datatype dataclass format Is is possible to export or create this view as a report ? because IA report gives lot...

i hope from "Table management" tab we can delete the reference table which stores frequency information in DB2. I deleted the reference tables belong to larger table but there is no change in database because db2 clear the table physically and reserve the tablespace . When i done column an...