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...?
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between odbc and drs stage?
Explain connectivity between datastage with datasources?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Explain entity, attribute and relationship in datastage?
What is the command line function to import and export the ds jobs?
What is a folder? Difference types of stages?
What is a datastage job?
what is the use of skid in reporting?
How a source file is populated?
in oracle target stage when we use load option and when we use upsert option?
Why fact table is in normal form?
client know skid info?
Explain how a source file is populated?
Explain ibm infosphere information server and highlight its main features?
How rejected rows are managed in datastage?