Using Schema file

pwwwchoi · Post by **pwwwchoi** » Tue Jul 25, 2006 9:57 pm

Hi,

I'm a newbie about schema file.

As I can see in the Parallel Job Developer's Guide (5-28),

(note, however, that if you have defined
columns on the Columns tab, you should ensure these match the
schema file)

Does that mean the column name and other properties on the Columns tab must match those in schema file? But not all columns must exist in both scheme file and Columns tab?

Thanks!

ray.wurlod · Post by **ray.wurlod** » Tue Jul 25, 2006 11:25 pm

All columns must exist in one or the other (or both). If runtime column propagation is disabled, all columns must exist in the link properties irrespective of what is in the schema file.

pwwwchoi · Post by **pwwwchoi** » Wed Jul 26, 2006 12:25 am

Just wanna clarify if my understanding is correct

e.g. Schema file has column "Car Code", "Car Name", "Car Description"

When RCP (runtime column propagation is disable

Column tabs of output link must have "Car Code", "Car Name", "Car Description", i.e. all columns.

When RCP (runtime column propagation is disable

Column tabs of output link can omit some columns. i.e. "Car Code", "Car Name" only is okay.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 26, 2006 3:51 pm

I do not use RCP, as it interferes with proper metadata management. Someone else will have to confirm this for you. It seems to accord with the description of RCP in the manual.

Klaus Schaefer · Post by **Klaus Schaefer** » Thu Jul 27, 2006 2:45 am

Even with RCP off you can work with a dataset and a partial schema definition. You can treat it like a relational table...

Once the dataset has been written, for reading it you can specify just the columns you need.

Klaus