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
what is the difference between == and eq in UNIX shell scripting?
What is the project in datastage?
Define meta stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How can we improve the performance in datastage?
How a routine is called in datastage job?
How to Remove Duplicate using SQL?
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 various kinds of containers available in datastage?
What is oci?
Can you explain repository tables in datastage?
How to clean the datastage repository?
How and where you used hash file?
What is aggtorec restructure operator?
What is ibm datastage flow designer?