DSXchange

Hi

My source columns are varchar ,decimal and Numeric
how can I validate them in transformer...

What exactly is your requirement? What is the stage you are using to read the data ? What is the target? Please provide more details

My source is a .csv file which I am reading from sequential stage
I guess I will need to validate them in transformer stage..
my target is a DB2 stage

Are the column data types of the target DB2 in sync with your source data? If yes, you can just import the metadata and do a straight move. If there are any not null fields in your target, you may need to handle nulls in transformer before loading the DB2.

actualy this is the requirement ..I need to show that the data coming from source file is valid..

Do you know what is the valid data or is there any requirement saying what exactly is valid data. Based on what the requirement is you have to do the validation.

So what exactly is Valid data for you?

Make use of the IsValid() function. That and ask yourself - what does an invalid varchar look like?

Business rules!! You need to become aware of the business rules that you have to enforce (for example a person's name may not contain a numeric character) and then implement these using DataStage logic. There is no "one size fits all" solution.