Question:
Can someone please reiterate to me the different "join" options when creating an infoset off of two ODS objects.
left outer joins means what?
inner join means what?
are these the only two options available?
Answer:
Left outer means data in the left table is selected even if there is not corresponding data in the right table .
Ex : If you join T1 and T2 on customer # and if T1 has a record for a customer that does not exist in T2 you'lls still see the data from T1.
In case of a inner join both tables need to have data on the joined fields.
I believe these are the only two options . There is no right outer join.
Hope this helps.