Lookup problem
Moderators: chulett, rschirm, roy
Lookup problem
Hi Folks,
How to specify this lookup condition in transformer;
Eff_str_dt<=ctrl_dt and Eff_end_dt>=ctrl_dt
Basically I am getting ctrl_dt as source and Eff_str_dt & Eff_end_dt in hash file.
Thanks,
Raj
How to specify this lookup condition in transformer;
Eff_str_dt<=ctrl_dt and Eff_end_dt>=ctrl_dt
Basically I am getting ctrl_dt as source and Eff_str_dt & Eff_end_dt in hash file.
Thanks,
Raj
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
With Server Job, Pretty much as you have specified.
Or are you looking for something else....
Code: Select all
In Constraints :
in.ctrl_dt >= Lkp.Eff_str_dt and in.ctrl_dt <= Lkp.Eff_end_dt
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
Eff_str_dt and Eff_end_dt are keys in hash file, I made link these two columns with ctrl_dt so hash file trying to match eff_dts with cntrl_dt but my condition is different. How to write this code in hash file key expression?
us1aslam1us wrote:With Server Job, Pretty much as you have specified.
Or are you looking for something else....Code: Select all
In Constraints : in.ctrl_dt >= Lkp.Eff_str_dt and in.ctrl_dt <= Lkp.Eff_end_dt
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can not perform a range lookup to a hashed file using a Hashed File stage. The Hashed File stage can only look for exact key values (which it does via the file's hashing algorithm, which is extremely efficient).
You can perform such a lookup against a hashed file using a UV stage, which accesses the hashed file using SQL. It will probably be slow unless you index the constraining columns.
You can perform such a lookup against a hashed file using a UV stage, which accesses the hashed file using SQL. It will probably be slow unless you index the constraining columns.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA