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
- 15481 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 will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are transforms and what is the differenece between routines and transforms?
What is the difference between in process and inter process?
root tree will find which is server job and which is parallel job?
Differentiate between hash file and sequential file?
What are the different kinds of views available in a datastage director?
What is oci?
options available in sequence job to run,validate?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Which warehouse using in your datawarehouse
How we can covert server job to a parallel job?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Explain usage analysis in datastage?
Differentiate between operational datastage (ods) and data warehouse?
How do y read Sequential file from job control?
