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.

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

Answer / subhash

One more Option is split the file into small files and Load
all files and send those to funnel to combind.

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

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

What is the difference between lookup and sparse lookup?

1 Answers  

what is use of SDR function?

0 Answers   CGI,

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

which memory is used by lookup and join

5 Answers   IBM,

Notification Activity

0 Answers   CTS,

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

How can we do null handling in sequential files

3 Answers   Reliance,

WHAT are unix quentios in datastage

2 Answers   TCS,

What is the sortmerge collector?

0 Answers  

What are operators in datastage?

1 Answers  

How to clean the datastage repository?

0 Answers