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 / subhash
One more Option is split the file into small files and Load
all files and send those to funnel to combind.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you reject records in a transformer?
What are stage variables and constants?
What is process model?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you explain repository tables in datastage?
I have a few records just I want to store data in to targets cycling way how?
Explain the importance of surrogate key in data warehousing?
What are the various kinds of containers available in datastage?
how can we create rank using datastage?what is the meaning of rank?
What is meta stage?
How can you write parallel routines in datastage PX?
Difference between sequential file and data set?
What are routines in datastage?
How do you remove duplicate values in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4