DSXchange

Hi,

I am having a couple of issues with data quality rules:

Firstly
=====

I have recently made some changes to a data quality rule:

Definition: DRD_CUSTOMER_NAME
Data Rule: DR_CUSTOMER_NAME

When I publish the rule I get:

Definition: DRD_CUSTOMER_NAME1 (new version)
Data Rule: DR_CUSTOMER_NAME (no change)

I can see the new and old definition in the data rule stage, so far so good.

However, if I export the new version (DRD_CUSTOMER_NAME1) from dev, when I import it in to prod I get the original version (DRD_CUSTOMER_NAME) without the changes I made.

It seems I cannot export/import rule definitions with versions.

Has anyone else come across this problem?

Am I doing anything incorrectly?

Secondly
======

Quite apart from the above, the implication is that you can use version 1 and 2 (or 3 or 4) as required. However, if the data bidnings changes between releases doesn't that render the previous version redundant?

It seems to me that the best approach would be for me to do versioning so I would get:

Definition: DRD_CUSTOMER_NAME01
Data Rule: DR_CUSTOMER_NAME01

Definition: DRD_CUSTOMER_NAME02
Data Rule: DR_CUSTOMER_NAME02

etc etc.

Many thanks and look forward to hearing from you.

Bob Oxtoby.

Hi Bob,

Your 'Firstly' sounds like a bug. How are you exporting/importing the DRD?

You mention the Rules Stage in DataStage/QualityStage. Is that your entire use case, or just one use case? In other words, are you also executing the DRD's in Data Rules in Information Analyzer?

Hi Robert,

I am exporting the Data Rule Definition and the Data Rule using the export and import option within IA on the Quality Console. I don't know of any other way, is there one?

For this particular exercise the rules are being execured by DataStage jobs but that's by the way really.

Kind regards,

Bob.