WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
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 iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Define data aggregation?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How to convert RGB Value to Hexadecimal values in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the differentiate between data file and descriptor file?
What are the functionalities of link collector?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Lookup constraints
What are the processing stages?
what are the errors,warnings in datastage
How many types of views are there in a datastage director?
Can you explain repository tables in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between an operational datastage and a data warehouse?