how to join the extra look up condition in the lookup
Posted: Fri Dec 22, 2006 5:16 am
Hi all,
I want to look up with a column of a particular table1 with another table2 column and also check that also check that the date column of table 2 is in between the 2 date columns of table 1
How can i do this in datastage?
The look up that i have used looks like
select table2.col3 where table1.colm1=table2.colm1 and table1.date between table2.startdt and table2.enddt
oraclestage------->transformer----->target
tabl.colm1
| tabbl2.colm1
table2.colm3
|
target look up
in this type of scenario how can we use the data range condition?
I want to look up with a column of a particular table1 with another table2 column and also check that also check that the date column of table 2 is in between the 2 date columns of table 1
How can i do this in datastage?
The look up that i have used looks like
select table2.col3 where table1.colm1=table2.colm1 and table1.date between table2.startdt and table2.enddt
oraclestage------->transformer----->target
tabl.colm1
| tabbl2.colm1
table2.colm3
|
target look up
in this type of scenario how can we use the data range condition?