Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9324 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
How many areas for files does datastage have?
What is the difference between operational data stage (ods) and data warehouse?
Why do you need stage variables?
root tree will find which is server job and which is parallel job?
Describe routines in datastage? Enlist various types of routines.
how to export or import the jobs in .ISX file
Define repository tables in datastage?
How to perform incremental load in datastage?
What is the difference between account and directory options ?
AGGREGATOR default datatype
How many types of views are there in a datastage director?
What are the processing stages?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
On which Dimension Table you implemented SCD Type in your Project
How will you move hashed file from one location to another location?
