Input column disabled for lookup stage

johnthomas · Post by **johnthomas** » Wed Nov 15, 2006 10:14 am

Hi , I have a job which has 6 lookup stages , But in some of the lookup stages the input columns option is disabled . Since this is required for setting the lookup condition , any clue what i am missing out here?

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Nov 15, 2006 10:47 am

mark the columns you want to lookup on as KEYS in the schema.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 15, 2006 10:56 am

Lookup keys are disabled in the Lookup stage (a) when the reference input link is fed from a Lookup File Set stage or (b) when the reference input link is fed from a directly-connected DB2 Enterprise or Oracle Enterprise stage. In both these cases the key is already known. The stream input link must have a key column that matches.

johnthomas · Post by **johnthomas** » Wed Nov 15, 2006 11:05 am

I use Oracle enterprise stage , and it works for some which has a reference link , i have checked the keys for the lookup in all the cases
??

johnthomas · Post by **johnthomas** » Tue Nov 21, 2006 4:42 pm

I now resolved the problem by removing the link and attaching the link back again with input link first to be attached to lookup stage and then the reference link. I thought Datastage is smart to handle that,but does not work that way

ray.wurlod · Post by **ray.wurlod** » Tue Nov 21, 2006 5:28 pm

You could simply have right clicked on the link and chosen Convert to Reference then on the other and chosen Convert to Stream.

DataStage can not read your mind!