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
Define project in datastage?
What are the some differences between 7.x and 8.x version of datastage?
Which commands are used to import and export the datastage jobs?
Which algorithm you used for your hashfile?
What is the process of killing a job in datastage?
Define Merge?
What are the different layers in the information server architecture?
How do u convert the columns to rows in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Define repository tables in datastage?
Describe routines in datastage? Enlist various types of routines.
What are the main features of datastage?
How to clean the datastage repository?
Define oconv () and iconv () functions in datastage?