Job design for two way range join
Posted: Mon Dec 21, 2015 5:51 am
Hi!
I am trying to implement a join between two tables with history in Datastage. In sql I would do something like:
Is there any neat way of doing this with Datastage components? I also want to make it generic by creating a shared container with RCP.
Thanks!
I am trying to implement a join between two tables with history in Datastage. In sql I would do something like:
Code: Select all
select *
from tableA a
left outer tableB b
on a.key = b.key
and (a.valid_from_date between b.valid_from_date and b.valid_to_date
or b.valid_from_date between a.valid_from_date and b.valid_to_date)
and b.valid_from_date >= a.valid_from_date
Thanks!