Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9323 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the areas of application?
how to sort two columns in single job in datastage.
What are the various kinds of containers available in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How to reverse the string using unix?
how to write server Routine coding?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the different layers in the information server architecture?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How do you import and export data into datastage?
To see hidden files in LINIX?
Name the different types of Lookups in Datastage?
Can you implement SCD2 using join, transformer and funnel stage?
