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
- 7675 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
what is the difference between == and eq in UNIX shell scripting?
How do you register plug-ins?
Enlist various types of routines in datastage.
Notification Activity
Name the different sorting methods in datastage.
What are routines in datastage? Enlist various types of routines.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to implement scd2 in datastage 7.5 with lookup stage
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Could anyone give brief explanation bout datastage admin
Is possible to create skid in dim,fact tables?
What is the flow of loading data into fact & dimensional tables?
What is a merge?
If you want to use a same piece of code in different jobs, how will you achieve this?
