Interested to Buy Any Domain ? << Click Here >> for more details...
Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 16644 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sadanand
HI All,
I would like to add one more point to JOIN.
To achieve full outer join the number of inputs need would
be only two.
The Primay table need to be sorted.
Memory used is very less compared to Lookup.
Regards,
Sadanand.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between operational datastage (ods) and data warehouse?
What are the different kinds of views available in a datastage director?
What are the components of ascential data stage?
Can you explain engine tier in information server?
What is staging variable?
If you want to use a same piece of code in different jobs, how will you achieve this?
client know skid info?
What is the use of hoursfromtime() function in transformer stage in datastage?
what is repositery?
Name the different sorting methods in datastage.
Which warehouse using in your datawarehouse
Have you used Unstructured data?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How many types of views are there in a datastage director?
What are some different alternative commands associated with "dsjob"?
