DS - Server Achieving a between condition in lookup
Posted: Wed May 18, 2005 7:41 am
Quick Question:
Is it possible to achieve a between condition coming from a lookup (hash file lookup, oracle source/stream link)?
i.e.
lookup: key_fields, beging_date, end_date
stream link: key_fields, actual_date
I want to find the key_fields that the source.actual_date falls between the begin and end date in the lookup. Is there any tricks in the transformer to force a between condidtion?
Is there any other solution aside from flattening out the lookup data to individual records or pushing the join back to the source?
Is it possible to achieve a between condition coming from a lookup (hash file lookup, oracle source/stream link)?
i.e.
lookup: key_fields, beging_date, end_date
stream link: key_fields, actual_date
I want to find the key_fields that the source.actual_date falls between the begin and end date in the lookup. Is there any tricks in the transformer to force a between condidtion?
Is there any other solution aside from flattening out the lookup data to individual records or pushing the join back to the source?