what is the best stage in datastage parller jobs to use full
out join and why
Answer Posted / bharath
Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Triggers,VIEW,Procedures
What is difference between server jobs & parallel jobs?
How you can fix the truncated data error in datastage?
Give an idea of system variables.
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
Explain the importance of surrogate key in data warehousing?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How and where you used hash file?
Differentiate between odbc and drs stage?
What is the differentiate between data file and descriptor file?
Define data aggregation?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Difference between server jobs & parallel jobs?
Can you implement SCD2 using join, transformer and funnel stage?
What is usage analysis in datastage?