Schema propagation warning

Jay · Post by **Jay** » Tue Jan 25, 2005 3:07 pm

Hi All,

I am getting the following warning at the Transformer stage.

TranEmployee_csv: When checking operator: Data set (Virtual dataset; output of "APT_TransformOperatorImplJob_TranEmployee_csv in TranEmployee_csv"; input to "Oracle_217.inEmployeeSort") has preset schema that differs from the propagated schema. Propagated fields not in existing schema will be dropped; fields in existing schema but not propagated will be defaulted.

It seems that due to this problem the rows are getting rejected. I might be wrong here...

Any ideas as to how to overcome this problem.

Thanks
Jay

ray.wurlod · Post by **ray.wurlod** » Tue Jan 25, 2005 4:16 pm

Just the obvious one - make sure that the schema (metadata) on both sides of the Transformer match.

Jay · Post by **Jay** » Tue Jan 25, 2005 4:53 pm

Thanks Ray. I'll keep you posted ....

T42 · Post by **T42** » Wed Jan 26, 2005 12:39 am

It could be caused by column propagation, especially on fields that you changed the metadata for but not the name. If you couldn't figure out how to address this, just turn off the column propagation for that stage, and see if that shut the log up.

Jay · Post by **Jay** » Wed Jan 26, 2005 1:37 pm

Its behaving funny ....

I matched both the schemas and am able to populate the target table , finally (sigh of relief!!!)...But i am still getting the warning of "Mismatched schemas"....Column propagation is set to off...

Thanks
Jay

T42 · Post by **T42** » Wed Jan 26, 2005 10:55 pm

I will definitely have to see the job and the log in order to figure out what went wrong.

Jay · Post by **Jay** » Wed Feb 09, 2005 5:44 pm

I am still getting this warning for all the PX jobs....

How will you see the job ? Shall i send you a dsx file ?