DSXchange

Most of the job log information is in a table named LOGGING%*%LOGGINGEVENTxxxxxxxx which makes job reports / statistics easy to generate. Where clause examples: CATEGORYNAME_XMETA = 'IIS-DSTAGE-RUN' (For Datastage jobs) LOG_SEQ=1 (To pick the latest run report) For design related information / repor...

This link might be of help:

http://www.laborkey.com/documentation/a ... ivers.html

Tables and columns in XMETA are reasonably meaningfully named which will make it easy for you to figure it out by yourself. There are few queries and hints already posted here. Refer these links: http://dsxchange.com/viewtopic.php?t=132865&highlight=xmeta&sid=83cc9389dde0e1c808940cf67093a044...

Override classification with Legend "R" for CHISWICK.

Data Rules (Rules analysis) were introduced post 8.0.1

Your issue & how to resolve it can be viewed in this link:

http://www-01.ibm.com/support/docview.w ... wg21317916

Reference #: 1317916

Use "T-Street Types" as classification for CASA (With standard form CASA) and VILLA (With standard form VILLA). This should do the job.

Have a reach here in dsxchange for "C2E76D84" and see. All the sites I'd gone had the same last eight characters, be the repository on DB2 or Oracle. Generic report creation for job design, logs, statistics & project auditing queries I created worked across the sites. According to Ray ...

XMETA (repository) provides this information in different tables. You can check there only by writing queries or get the information into a spreadsheet to generate a report with the standards defined there. In the table name like DATASTAGEX%*%DSJOBDEFC2E76D84 you will get CATEGORY_XMETA (For folder ...

Search your XMETA (repository) for columns NAME_XMETA (For the Job Name)& XMETA_MODIFIED_BY_USER_XMETA (For the user) in table name like
DATASTAGEX%*%DSJOBDEFC2E76D84 with where clause for job name(s).

The latest version of QualityStage surprisingly did not have a rule set for Australian Phone Numbers and that leaves us with the only option of creating one by ourselves. I have have a blog on this if you want to refer : http://it.toolbox.com/blogs/dw-soa/qualitystage-rule-set-for-australian-phone-n...

I doubt if you have purchased "QualityStage WAVES" database. Those rulesets you see under the folder WAVES Rules are used for standardizing purpose, but the stage expects country-specific postal reference files (Waves Database) for address correction, verification and enhancement.

Have you purchased reference database for WAVES?

XMETA (Repository) will be the right place to look for to generate such a report in 8x versions (Infosphere) especially if logging on to XMETA is switched on.

While you create Parameter Set chose your parameters from the environment parameter option and enter $PROJDEF as values.