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
- 16619 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
in oracle target stage when we use load option and when we use upsert option?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How do you import and export data into datastage?
How a server job can be converted to a parallel job?
which r the connectors used in san?
Notification Activity
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?
On which Dimension Table you implemented SCD Type in your Project
Difference between sequential file and data set?
how to implement scd2 in datastage 7.5 with lookup stage
What are some prerequisites for datastage?
What are the functionalities of link collector?
table actions available in oracle connector?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
