Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7793 Views
- IBM, I also Faced
- E-Mail Answers
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
How do u convert the columns to rows in datastage?
Lookup constraints
What are the various kinds of the hash file?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between datastage and datastage tx?
What are stage variables?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How many types of views are there in a datastage director?
What is quality stage?
how to delete one row in target dataset
What are the job parameters?
What is oci?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are iconv and oconv?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
