Stage and Lookup Condition Tabs not shown in my Lookup stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Stage and Lookup Condition Tabs not shown in my Lookup stage

Post by tbtcust »

Hi all.

The Stage and Lookup Condition Tabs is not shown in my Lookup Stage. Also, the Input tab is not showing.

I have the Lookup Stage with three links, i.e., output, reference, and input. The job is aborting with the following "StageName,0: Failed a keylookup for record."

I'm need to set the failed rule from "Fail" to "Drop".

When I double click on the stage. Only the output mapping metadata is being displayed. The stage and Input tabs are missing. Can someone help.


Thanks in advance for any help.
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: Stage and Lookup Condition Tabs not shown in my Lookup s

Post by sud »

You should double click on the "Condition" box in the reference metadata box within the lookup stage.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

sud, I'm in parallel. I'm looking at the documentation and see the tabs there. But it seems to be hidden in the stage.
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Post by sud »

what is hidden? the input links or the place where you want to make "fail then continue"?
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

the place where I want to make "fail then continue"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does your Lookup stage have two inputs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bkumar103
Participant
Posts: 214
Joined: Wed Jul 25, 2007 2:29 am
Location: Chennai

Post by bkumar103 »

the place where I want to make "fail then continue"
to get the place where you can specify this
double cleck the lookup stage then at the top right corner click constraints from too bar. The option will be displayed.
Birendra
Post Reply