Metadata mismatch in Universe stage

[ritanya]

Hi All,
We have to implement some conditional lookup's (e.g dat1>=date2) in the job. So, while creating the hash files, we have checked the universe stage compatibility option and We are using the universe stage in the main job to achieve this. But, When we run the job using hash file through the Universe stage we are getting the warning message saying "Meta Data MisMatch".
The warning messages are like:
MetaData mismatch COLUMN.TYPE Expected = Char Actual = VarChar
MetaData mismatch COLUMN.PRECISION Expected = 10 Actual = 11

Please let me know how to get rid of this warning message. Please let me know the solutions for this.

Thanks

 

[JGirl]

Hi,

These messages are just datastage telling you that the data it is reading isnt in the format that you have specified. ie. The messages below are saying that you have specified Char data type for the TYPE column, but the data type is actually VarChar, and you have specified a length of 10 for the PRECISION colum, but the actual length is 11.

MetaData mismatch COLUMN.TYPE Expected = Char Actual = VarChar
MetaData mismatch COLUMN.PRECISION Expected = 10 Actual = 11


To get rid of these warning messages is easy - open your hash file stage, and change the 'SQL Type' value of the TYPE column from 'Char' to 'VarChar', and change the length of the PRECISION column from 10 to 11.

Cheers
J