DataStage functionality to perform a lookup for a type 2 dim
Posted: Thu Dec 25, 2003 11:49 am
Does anybody know how to do a lookup against a type 2 dimension within a transformer?
If done in sql, the where clause would use a bewteen e.g
where source.tran_date bewteen lookup.from_date and lookup.to_date
and source.id = lookup.id
I have a lookup with a composite primary key on id, from_date and to_date
The main input link has an id, tran_date and the facts.
I need to use this to load history data (we cannot do incremental or delta loads) and need to find the correct wh_key values.
I could email you a dsx file and some sample data. My email address is eldonp@lantic.net
If done in sql, the where clause would use a bewteen e.g
where source.tran_date bewteen lookup.from_date and lookup.to_date
and source.id = lookup.id
I have a lookup with a composite primary key on id, from_date and to_date
The main input link has an id, tran_date and the facts.
I need to use this to load history data (we cannot do incremental or delta loads) and need to find the correct wh_key values.
I could email you a dsx file and some sample data. My email address is eldonp@lantic.net