Page 1 of 1
Left outer join
Posted: Mon Aug 20, 2007 4:31 pm
by chandra
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--
Posted: Mon Aug 20, 2007 5:37 pm
by ray.wurlod
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?
Posted: Mon Aug 20, 2007 11:34 pm
by bcarlson
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.
Posted: Wed Apr 02, 2008 2:21 am
by Vengadeshwaran v.j
Get the details from the Link Ordering Tab
Posted: Wed Apr 02, 2008 2:23 am
by Vengadeshwaran v.j
Get the details from the Link Ordering Tab
Posted: Wed Apr 02, 2008 6:10 am
by sunayan_pal
open the join stage
in the Link ordering tab of the Stage page you can see the left and the right one.