Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43339 Views
- MCA, Symphony, TCS, I also Faced
- E-Mail Answers
Answer Posted / veera
HI
1. sorted the data as much as possible in sourc database
2. Remove the unwanted columns from soure DB.
3. Drop the indexes before loading the data and Recreate
after loading the data
4. not use more than 20 stages in a job
5. Reduce the Tx stage
6. Use sort stage before an Aggregator stage (in sort mode)
7. Tuned the Project tunnables in administator for better
performance
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is job control?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Does datastage support slowly changing dimensions ?
What are datastage sequences?
What is a quality stage in datastage tool?
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 to manage date conversion in Datastage?
Explain the importance of surrogate key in data warehousing?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the different type of jobs in datastage?
What is the roundrobin collector?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is a datastage job?
How will you move hashed file from one location to another location?
