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
- 15267 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rajeshchunduri
in emp and dept tables key column is deptno so it is key
based and datatype for key column is int . At this time we
change partion tech from hash to modulus.
chunduri
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between datastage and datastage tx?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
in oracle target stage when we use load option and when we use upsert option?
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 is ibm datastage?
How do you import and export the datastage jobs?
What is the importance of the exception activity in datastage?
What is the difference between passive stage and active stage?
What are the functionalities of link collector?
What is oci?
Define repository tables in datastage?
Can we use target hash file as a lookup ?
What is the difference between hashfile and sequential file?
