LKP Stages In Jobs

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
sushanth
Participant
Posts: 18
Joined: Sat Oct 09, 2004 10:13 am
Location: Malaysia
Contact:

LKP Stages In Jobs

Post by sushanth »

HAi DSFolks
Can we use More than 30 Lkps Stages in a single Job There are some Error
when we Run the Job ! Have you faced the same in your environment
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard! :D

You really have not given us enough information to help. Please post the exact error message(s) from the log, or from the compilation phase if this is where it is occurring.

It may even be that none of your Lookup stages is responsible; without seeing the actual error message(s) we can't tell.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

There is no real limit as far as the number of lookups. I have seen jobs with hundreds. I do not recommend that but 30 is not a problem.
Mamu Kim
sanjay
Premium Member
Premium Member
Posts: 203
Joined: Fri Apr 23, 2004 2:22 am

Re: LKP Stages In Jobs

Post by sanjay »

Yes
if u have lof of duplicate records in lookup and u have not handle duplicate records it will give an error

Sanjay
sushanth wrote:HAi DSFolks
Can we use More than 30 Lkps Stages in a single Job There are some Error
when we Run the Job ! Have you faced the same in your environment
Thanks
vbeeram
Participant
Posts: 63
Joined: Fri Apr 09, 2004 9:40 pm
Contact:

Post by vbeeram »

There is no limit of Lookups in a job we used more than that u specifed number.


Regards
Beeram
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There are some Error when we Run the Job !
This is akin to "there is some problem when we start the car". Very difficult to diagnose on that information alone.

You need to be more specific about the circumstances, the symptoms, the error messages, and any assumptions you are making.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply