DSXchange

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

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.

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

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

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