Lookup

cherry · Post by **cherry** » Tue Mar 09, 2010 12:56 am

Hi All,

We recently upgraded from 8.0.1.2v to 8.1.00v.

In 8.0.1.2v iam doing lookup directly on the table. But the same job design is not working in 8.1.00v.

In 8.1.00v, I need to add a hash file for the lookup to work.

Do any one has an idea why is this change.

Regards
Cherry.

cherry · Post by **cherry** » Tue Mar 09, 2010 1:06 am

Hi All,

In My previous message I have mentioned, the job type as Parallel.

The job type is server.

Many Thanks

Regards
Cherry

ArndW · Post by **ArndW** » Tue Mar 09, 2010 2:32 am

Could you explain the error you are getting with the direct lookup at 8.1; there is no reason I can think of why that shouldn't work.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 09, 2010 2:58 am

We have no idea of what "not working" means in this context.

Explain exactly what you are doing, including the data types of the reference key column and the column from the stream input that is mapped to it.

Mention, too, whether any error or warning message is logged in the job log.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 09, 2010 3:00 am

Moderator: please move to server forum