partial schema

legendkiller · Post by **legendkiller** » Mon Sep 11, 2006 9:24 am

hi...

i am reading a file using schema file....if I have schema file having columns say A,B,C and acutal data in file contain only two columns.....then is it possible to read that data file.....

IS RCP or partial schema property is useful for above step

thanks in advance
LK

ray.wurlod · Post by **ray.wurlod** » Mon Sep 11, 2006 3:36 pm

No. RCP handles missing metadata, not missing data. You need to specify a default value in the column metadata to handle the situation you described.

legendkiller · Post by **legendkiller** » Tue Sep 12, 2006 8:23 am

ray.wurlod wrote:No. RCP handles missing metadata, not missing data. You need to specify a default value in the column metadata to handle the situation you described. ...

Thanks ray,

I also want to know whether it is possible to decribe partial schema and read the file with above case.

Thanks and regards
LK

thumsup9 · Post by **thumsup9** » Tue Sep 12, 2006 8:38 am

I think it will throw a warning saying too many columns in record, but yes you read the record.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 12, 2006 4:03 pm

To put that another way, DataStage must be able to construct the full schema from somewhere - whether internal metadata or an external schema file.