Table_A
PROD1, MFGSTARTDATE, MFGENDDATE
Table_B
PROD1, QADATE
I have to pass the records only when the 'QADATE' is
between 'MFGSTARTDATE' and 'MFGENDDATE'
Can anyone tell me which stage to use to achive this.
Thanks in advance.
How to do look for the greater than or less than date ranges
Moderators: chulett, rschirm, roy
Re: How to do look for the greater than or less than date ra
we can achive this by writing a constraint in the target
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
Instead of the server shared container, check if the sparse lookup can be used. Sparse lookup allows you to fire queries at runtime. So you have to define Table_A as reference link with key columns mapped to QADATE.
Then in SQL in TABLEA, add the query which will have range condition.
But keep in mind - sparse lookups hit the performance. In case of sparse lookup, query is prepared with the value coming from stream link and then fires it on database.
Then in SQL in TABLEA, add the query which will have range condition.
But keep in mind - sparse lookups hit the performance. In case of sparse lookup, query is prepared with the value coming from stream link and then fires it on database.
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: