Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9105 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 |
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how many stages are there in Datastage... Please clarify mee??
Can we use target hash file as a lookup ?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
wt is the difference between swith and filter stage
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
What is the default execution order of the sequential file?
Enlist various types of routines in datastage.
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
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...
What is usage analysis in datastage?
Name the command line functions to import and export the DS jobs?
Teradata 
