How to implement complex jobs in Data Stage?


-Complex design refers to the more joins and more look ups.

The performance can be increase by

a)You need to restrict the maximum stages for every job to 20 .

b)Avoiding more than the seven look ups per transformer

Read more Datastage Interview Questions Here

  • Anonymous

    If huge data need to be sorted and it's huge then go for sort stage, use modify stage it can do wonders just takes more efforts to write specifications.