Interested to Buy Any Domain ? << Click Here >> for more details...
if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 15462 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / professional
Hi,
For the above query to improve the performance based on key columns in emp and dept joins by default sort in datastage for better performance if you have already a sorted data just go for environmental variables and do the operation #APT_Not_SORTDATA option then performance increase automatically...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oci?
How the ipc stage work?
Does datastage support slowly changing dimensions ?
what is the difference between == and eq in UNIX shell scripting?
What are sequencers?
Where the datastage stored his repository?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
In Datastage, how you can fix the truncated data error?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the different kinds of views available in a datastage director?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is the use of materialized view?
Define Data Stage?
How will you move hashed file from one location to another location?
