How to Validate the data in Target files?

[Developer9]

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 )???

[SURA]

Asked: 1.Data trasformation for Date fileds.
What transformation are you trying to do?

Asked:Qn:How to Validate the data in Target files ??
What to validate?

DS User

[ray.wurlod]

Start by specifying (on paper) what your validation rules are.

[Developer9]

Asked: 1.Data trasformation for Date fileds.
What transformation are you trying to do?

Re: For Example,I have some date fields present has Nullable as source so I want to give Default value in my target as 0000-00-00 if it is NULL

Asked:Qn:How to Validate the data in Target files ??
What to validate?

Re: For Example:I have one field for Credit score ,I want to give a range for that suppose in the Increment of 200.say 0-200,201-400 like 701-900

For that I applied some logic in transformer.

Now I want to validate the records in my target corresponding to source.

Ex:check

for ID Say

000101000 credit score 252 >>>source
000101000 range 201-400 >>>target

like wise for all the records ..

Is there any way to perform check ???

Thank you

[ray.wurlod]

Yes, though obviously separately for separate fields.

NullToValue() is probably sufficient for your first example.

The two ends of the range will be derived by simple arithmetic involving integer division by 200 and modulus operations.