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
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 |
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 |
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 |
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 |
what is the custome stage in datastage? how can we impliment that one? plz tell me
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
What is difference between 8.1 , 8.5 and 9.1 ?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
how to call sequential generator in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Hi Vijay here For Four CPU's how many nodes will required?
how to configure databases through datastage
What is lookup table?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
Define repository tables in datastage?