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
- 15487 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
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
What is datastage engine?
Define orabulk and bcp stages?
What is difference between symmetric multiprocessing and massive parallel processing?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
In Datastage, how you can fix the truncated data error?
Have you used Unstructured data?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Highlight the main features of datastage?
Difference between data warehousing and olap?
Explain datastage architecture?
How can one find bugs in job sequence?
What are the components of datastage?
What are stage variables and constants?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
