Is it Achievable with Schema file

har · Post by **har** » Thu Dec 06, 2007 3:01 pm

All,
Let me start from here:
Scenario 1:
Say my Source field datatype is Date(yyyy-mm--dd)(EX:2007-01-10).
And if i define meta data in schema file like this date[mm-dd-yyyy](Ex : 01-10-2007),does the data will change automatically or not.

Scenario 2:
Say my input datatype for one field is Decimal(Ex : 000123.456).
Is their a way that i can convert this to 123456 by defining some thing in schema file.

Is it possible to do any type conversion with schema file.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Thu Dec 06, 2007 3:46 pm

Nothing is automatic. Data types will be converted implicitly if this is feasible, but will generate warnings/errors if not.

har · Post by **har** » Thu Dec 06, 2007 4:26 pm

Ray,
U mean,Job will run successfull with out any fatal errors.
Usually Transformer stage do all type conversions..
I mean does implict conversion will happen with Schema File with out any fata errors.
Thanks,
Har