i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
Answer Posted / krishna
1) In sequential stage we have stage properties on that
select options and increase the readers
2) In datastage admin we have on environmental variable like
logical reader that set as one
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to find value from a column in a dataset?
What is the difference between validated and compiled in the datastage?
Triggers,VIEW,Procedures
What is "fatal error/rdbms code 3996" error?
What are the various kinds of the hash file?
How many types of stage?
What is the difference between passive stage and active stage?
What are routines in datastage?
Why do we use link partitioner and link collector in datastage?
What is the importance of the exception activity in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How many types of hash files are there?
how can we create rank using datastage?what is the meaning of rank?
How do u convert the columns to rows in datastage?