Page 1 of 1
Performing Outer join in Server jobs
Posted: Fri Nov 04, 2005 4:07 pm
by bobthebuilder
Any suggestions in performing outer joins in Server jobs other than defining a user defined query
--Bob
Posted: Fri Nov 04, 2005 5:27 pm
by Bala R
Reference lookups using OCI, ODBC or Hashfiles. Do a search for outer join.
Posted: Sat Nov 05, 2005 2:55 am
by ray.wurlod
Anything in the Table Name field becomes the FROM clause in the SELECT statement in Generated SQL.
You can quite happily put things like
Code: Select all
#Schema#.Employee T1 LEFT OUTER JOIN #Schema#.EmployeeDependent T2 ON T1.EmployeeID = T2.EmployeeID
into the Table Name field. If you use aliases like that, make sure that the Derivation column in the Columns grid uses the same aliases.
Posted: Sun Nov 06, 2005 7:09 pm
by rleishman
The SQL Builder in 7.5.1A - despite its problems (
viewtopic.php?t=96324&highlight=) - does have a marked improvement in producing outer joins.
Posted: Mon Nov 07, 2005 2:25 am
by ray.wurlod
Neglected to mention that the Merge stage performs any kind of key-based join between two text files.