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
- 16331 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
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the components of datastage?
What are the different options associated with dsjob command?
What is "fatal error/rdbms code 3996" error?
Difference between sequential file and data set?
What is job control?
AGGREGATOR default datatype
Why we use surrogate key?
What are the components of ascential data stage?
How do you reject records in a transformer?
What is the differentiate between data file and descriptor file?
How to implement complex jobs in data stage?
Can we use target hash file as a lookup ?
How do you run datastage job from the command line?
