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 / bharath

It can be achieved by DEGREE OF PARALLELISM.
i.e, we can configure the multiple nodes in the configuration
file. In configuration file we can specify multiple nodes..

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various kinds of containers available in datastage?

556


How one source columns or rows to be loaded in to two different tables?

653


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3365


What is a folder? Difference types of stages?

616


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2002






How rejected rows are managed in datastage?

909


What are stage variables?

628


Define repository tables in datastage?

694


If you want to use the same piece of code in different jobs, how will you achieve it?

625


What is the difference between in process and inter process?

659


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?

1753


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1738


table actions available in oracle connector?

1082


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4551


What is ibm datastage flow designer?

676