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
- 12590 Views
- TCS, I also Faced
- E-Mail Answers
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
Have you have ever worked in unix environment and why it is useful in datastage?
Define data aggregation?
What are the types of views in datastage director?
How do you import and export the datastage jobs?
project Steps,hits, Project level HArd things,Solved methods?
AGGREGATOR default datatype
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is the use of datastage director?
How one source columns or rows to be loaded in to two different tables?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is "fatal error/rdbms code 3996" error?
How a routine is called in datastage job?
What is active and passive stage?
How can we improve the performance in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
