How to Validate the data in Target files?
Posted: Tue Jul 26, 2011 12:37 pm
Hi All,
I am using Datastage V7.5.2 ..
I Used the Chage capture stage to capture the changes in my source data.
OR
In general source >>>transformation>>>>target
(thosands rows) (thousands rows)
Transformation:
1.Data trasformation for Date fileds.
Qn:How to Validate the data in Target files ??
My Understanding:
If it is countable (like 10,20...)rows we can check source rows and corresponding target rows and validate whether particular record is transformed or not .
But here thousands of rows ..Is there any method to follow for validation.(Logic perfomed or not on particular row )???
I am using Datastage V7.5.2 ..
I Used the Chage capture stage to capture the changes in my source data.
OR
In general source >>>transformation>>>>target
(thosands rows) (thousands rows)
Transformation:
1.Data trasformation for Date fileds.
Qn:How to Validate the data in Target files ??
My Understanding:
If it is countable (like 10,20...)rows we can check source rows and corresponding target rows and validate whether particular record is transformed or not .
But here thousands of rows ..Is there any method to follow for validation.(Logic perfomed or not on particular row )???