Left outer join

chandra · Post by **chandra** » Mon Aug 20, 2007 4:31 pm

how to find which one is left dataset / right dataset in join.

A--

--join-- assume iam doing leftouter join, how find which one left Ds
b--

ray.wurlod · Post by **ray.wurlod** » Mon Aug 20, 2007 5:37 pm

Find a tab in the stage called Link Execution Order (on the Inputs tab). This will show which is which and, indeed, allow you to change them. Once your voyage of discovery is complete, why not use small annotations to label the inputs on your graphical job design?

bcarlson · Post by **bcarlson** » Mon Aug 20, 2007 11:34 pm

It is also helpful to use logical names on your links. A link from a customer table read could be cust_read_lnk, joined to customer/address file with a link called cust_addr_lnk. Then it is easier when you assign your left/right sides of your join and the stage is self documenting.

Brad.

Vengadeshwaran v.j · Post by **Vengadeshwaran v.j** » Wed Apr 02, 2008 2:21 am

Get the details from the Link Ordering Tab

Vengadeshwaran v.j · Post by **Vengadeshwaran v.j** » Wed Apr 02, 2008 2:23 am

Get the details from the Link Ordering Tab

sunayan_pal · Post by **sunayan_pal** » Wed Apr 02, 2008 6:10 am

open the join stage
in the Link ordering tab of the Stage page you can see the left and the right one.