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
- 14059 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
How to RD using transformer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you define merge?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the types of containers and how to create them?
What are iconv and oconv?
What is the differentiate between data file and descriptor file?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Nls stands for what in datastage?
Explain connectivity between datastage with datasources?
Difference between data warehousing and olap?
How do you start developing a datastage project?
What all are the different way to run a job?
