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 / 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 |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
What all are the different way to run a job?
What are the differences between datastage and informatica?
How do you import and export the datastage jobs?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How can you write parallel routines in datastage PX?
What are the types of containers?
What is the difference between informatica and datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
AGGREGATOR default datatype
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between operational data stage (ods) and data warehouse?
EXPLAIN SCD
What are the various kinds of containers available in datastage?
What are the benefits of datastage?