what is the differeces between hash and modulus partition
methods
Answer Posted / kiran
hai this is Kiran..,
If the key field is numeric use modules else hash
partition.as per performance tuning.
Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
How do u convert the columns to rows in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Describe the main features of datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
To see hidden files in LINIX?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the types of containers in datastage?
Nls stands for what in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Is the value of staging variable stored temporarily or permanently?
CHANGE CAPTURE
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)
how to sort two columns in single job in datastage.
What is the difference between orabulk and bcp stages?