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

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

What are the components of ascential data stage?

0 Answers  

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

0 Answers   Accenture,

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

How can we achive parallelism

1 Answers   CTS,

What is a datastage job?

0 Answers  

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

What is the difference between informatica and datastage?

0 Answers  

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,