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...?

Answers were Sorted based on User's Feedback



i have seq file that contents 10 million records load to target any data base.. in that case it t..

Answer / subhash

1.Increase the 'Numbers Readers per Node' to '2' in source file.
2. Use the Bulk Load Option in Target Oracle Connector.
3. set option Re-Build Index option, so that it will drop indexes before loading and It will create the indexes once load is completed.
4. Increase the 'Record count'(set 10,000, should be multiple of Array size) in TGT.
5. Increase 'Array size'(set 5,000, default is 2,000) in TGT.
6. SRC---->COPY---->TGT,
use COPY stage, so, it work like buffer whenever there is diff in number records processing at source side and at target side.

Is This Answer Correct ?    10 Yes 0 No

i have seq file that contents 10 million records load to target any data base.. in that case it t..

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

i have seq file that contents 10 million records load to target any data base.. in that case it t..

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

i have seq file that contents 10 million records load to target any data base.. in that case it t..

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

i have seq file that contents 10 million records load to target any data base.. in that case it t..

Answer / prasad

In Seq file, we have one property called no. of readers/node(by default is one)=4 and

in Target table use "Bulk load" and also use Round Robin partition.

first drop index before loading data and once data loaded then re-create index again.

Plz correct me, if i am wrong.....

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,


What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,


diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


how to call sequential generator in datastage?

1 Answers   IBM,






What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  


Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,


how to configure databases through datastage

2 Answers  


What is lookup table?

5 Answers  


I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,


1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,


Define repository tables in datastage?

0 Answers  


Categories