Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 15381 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
How a source file is populated?
Define project in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Differentiate between validated and Compiled in the Datastage?
State the difference between an operational datastage and a data warehouse?
Define APT_CONFIG in Datastage?
What is the purpose of pivot stage?
Triggers,VIEW,Procedures
What is the importance of the exception activity in datastage?
Can we use target hash file as a lookup ?
What are system variables and sequencers in datastage
What a datastage macro?
What is the difference between odbc and drs stage?
How many types of sorting methods are available in datastage?
