if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 13496 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
How a source file is populated?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the use of datastage director?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the method of removing duplicates, without the remove duplicate stage?
how to abort the job its matain duplicates?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between informatica and datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Explain datastage architecture?
Explain the situation where you have applied SCD in your project?
What is the difference between passive stage and active stage?
what is the use of skid in reporting?
How many types of sorting methods are available in datastage?
Describe link sort?
