sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

 

what do u mean by complex jobs.

if u used more than 15 stages in a job and if you used 10 lookup tables in a job then u can call it as a complex job

sekr

 Profile Answers by sekr Questions by sekr

• Jan 30th, 2006

 

question not clear ?

Sharanu Patil

• Feb 28th, 2006

 

any type of complex jobs can be easily implemented just like other ETL Tools

RamaPrasad Batchu

• Mar 9th, 2006

 

Complex design means having more joins and more look ups. Then that job design will be called as complex job.We can easily implement any complex design in DataStage by following simple tips in terms of increasing performance also. There is no limitation of using stages in a job. For better performance, Use at the Max of 20 stages in each job. If it is exceeding 20 stages then go for another job.Use not more than 7 look ups for a transformer otherwise go for including one more transformer.Am I Answered for u'r abstract Question.

arun

• May 30th, 2006

 

  if the job have good logic that is called as complex job.

simply we can say Scenarios .so If you have faced any complexity while creating job please share with us.