Interested to Buy Any Domain ? << Click Here >> for more details...
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...?
- 5 Answers
- 14553 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Where the datastage stored his repository?
Why we use surrogate key?
What is a merge in datastage?
What a datastage macro?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
On which interface you will be working as a developer?
in oracle target stage when we use load option and when we use upsert option?
What can we do with datastage director?
Difference between data warehousing and olap?
How to manage date conversion in Datastage?
What is datastage?
How and where you used hash file?
What are stage variables and constants?
What is the flow of loading data into fact & dimensional tables?
Explain the situation where you have applied SCD in your project?
