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
What is the use of hoursfromtime() function in transformer stage in datastage?
How to reverse the string using SQL?
What are transforms and what is the differenece between routines and transforms?
Describe the architecture of datastage?
Where do you see different stages in the designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the stages in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How do you run datastage job from the command line?
What is ds designer?
Which commands are used to import and export the datastage jobs?
How one source columns or rows to be loaded in to two different tables?
Can you explain tagbatch restructure operator?
What is the flow of loading data into fact & dimensional tables?