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
- 15459 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / poorna chandra
Hi this is Poorna ,
We can Improve the performance on join stage by doing
pre sorting for both left and right data based on
key .Then we can Improve the performance in join stage .
Plz correct me if any mistake in thinking .
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
What a datastage macro?
What is meta stage?
what is the use of skid in reporting?
How to manage date conversion in Datastage?
How and where you used hash file?
To see hidden files in LINIX?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Which algorithm you used for your hashfile?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What steps should be taken to improve Datastage jobs?
Explain Quality stage?
What is orabulk stage?
How one source columns or rows to be loaded in to two different tables?
Name the different sorting methods in datastage.
