A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
Answer Posted / datastage4you
You can try to put a copy stage with force=True propertly. It can inhance the performance
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain link buffering?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How the ipc stage work?
How do you reject records in a transformer?
What can we do with datastage director?
What are transforms and what is the differenece between routines and transforms?
What is the purpose of pivot stage and types of containers in datastage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the difference between an operational datastage and a data warehouse?
What are the different type of jobs in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the areas of application?
What is the difference between in process and inter process?