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
- 15277 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kiran
when ever join 2 tables based on key columns if the key
column is numeric ,set modulus,if the key column is non
numeric set hash partition technique.and compare to look up
join give better performance coz join has sort operation
by default.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Difference between in process and inter process?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is data partitioning?
What are routines in datastage? Enlist various types of routines.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the purpose of interprocessor stage in server jobs?
EXPLAIN SCD
What are the main differences you have observed between 7.x and 8.x version of datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do you register plug-ins?
How can we improve the performance in datastage?
What are the functionalities of link collector?
How to perform incremental load in datastage?
explain about citrix scheduling tool in datastage
What can we do with datastage director?
