Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9237 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How many areas for files does datastage have?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the use of hoursfromtime() function in transformer stage in datastage?
in oracle target stage when we use load option and when we use upsert option?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the difference between the local container and shared container?
how to abort the job its matain duplicates?
How do you run datastage job from the command line?
Have you used Unstructured data?
Explain the situation where you have applied SCD in your project?
What is a datastage job?
Differentiate between datastage and informatica?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how do u catch bad rows from OCI stage? And what CLI stands for?
