L4-Transformation Accessment

zhaicaibing · Post by **zhaicaibing** » Sat Jul 05, 2003 8:32 am

Hi,

Can anyone give me an example of the data filter on how to analyse L4?

In L0, we can use base check type and produce an exception table that contain the column and the count of that column.

In L1, we can use exist to access the completeness and in ref list and in range to access the validity.

In L2, we can use unique to check the duplicates and in ref col to check referencial integrity.

In L3, we can use type, format...... to check the business rules.

How about L4?

Thanks,
Cai Bing

ray.wurlod · Post by **ray.wurlod** » Sat Jul 05, 2003 7:18 pm

L4 is Transformation Rules Compliance. Here you simulate transformation from source data to target data, and perhaps search for alternative transformation logic that might improve the end results (for example whether particular cases (NULL?) have been handled "properly"). You also verify, of course, that the initial transformation has taken place correctly, by surveying target data and comparing results against expectations.
The actual techniques you use are, clearly, going to be very dependent on the transformation rules and on how you've implemented them. Reading the L4 section in the QM manual may be a great help, even if their examples don't correspond exactly with what you want to do.