Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9100 Views
- GE, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kpk
1) Use user defined queries for extracting data from databases.
2) Use native databases stages rather than using ODBC.
3) Use sql join statement rather than using a lookup stage,
if the data is less.
4) Tune the SQL query (the select statement used to extract
the data from source)
5) use less oracle stages, less transformers and lookup
stages, if you have more number of stages, divide the job
into multiple jobs.
6) if ur using server jobs use IPC, Partitioner, collector.
7) if using parallel job then set the environmental variable
APT_DUMP_SCORE to TRUE. this will give a job report that
will show you what are all the operators inserted by
datastage (like sorting, needed or uneeded partition and
collection), so u can manually change the partition methods.
.... most of the performance tunning steps depends on the
job design.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / kiran
1.In drvition ,Instead of calling routines implementing
stage variales.
2.while using ODBC Stag,adjust as per row seetings.
3.using user defined queiries while Extract the date from
sorce.
4.minimize null values
5.minimize unused columns
6.minimize warninigs
7.don't use more than 7 look up in a job,if exceede take
another transformer.
8.don't use morethan 20 stages in a job.
9.before loading data drop indexes after re created indexes.
10.worked with DBA-Admin for
11.tuned in Project tunes in Datastage Admin
12
13
14
15
16
| Is This Answer Correct ? | 4 Yes | 0 No |
Can you filter data in hashed file?
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
explain about citrix scheduling tool in datastage
tell me abt Datastage trigger?
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?
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.
how many rows sorted in sort stage by default in server jobs
What are datastage sequences?
how to load meta data
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Teradata 
