Difference in the implementation of lookup and join
stages,in joining two tables?
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
Describe the architecture of datastage?
Describe stream connector?
How many types of sorting methods are available in datastage?
Differentiate between datastage and informatica?
On which interface you will be working as a developer?
How do you reject records in a transformer?
What is the difference between datastage and datastage tx?
How to Remove Duplicate using SQL?
Can we use target hash file as a lookup ?
AGGREGATOR default datatype
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are datastage sequences?
What is the difference between operational data stage (ods) and data warehouse?
Name the different types of Lookups in Datastage?
How you Implemented SCD Type 1 & Type 2 in your project?