if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 13457 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
what is ds administrator used for?
Is possible to create skid in dim,fact tables?
Which algorithm you used for your hashfile?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How we can covert server job to a parallel job?
How to read multiple files using a single datastage job if files have the same metadata?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain ibm infosphere information server and highlight its main features?
Define ds designer?
What are the processing stages?
What are stage variables, derivations and constants?
What are the functionalities of link partitioner and link collector?
What are the types of jobs we have in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
