1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / rameshkumar.boddu

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

how can u handle null values in transformer stage.

7 Answers  

Name the different sorting methods in datastage.

0 Answers  

How can we achive parallelism

1 Answers   CTS,

How complex jobs are implemented in datstage to improve performance?

0 Answers  

What are orabulk and bcp stages?

0 Answers  




how many write modes are there in ds

2 Answers   IBM,

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

Define ds designer?

0 Answers  

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

Main Function of the Staging area in DWH ?

2 Answers  

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

For more Data Stage Interview Questions Click Here
Categories