Type 2 slowly changing dimensions
Posted: Tue May 31, 2005 8:48 pm
Hi
I an new to datastage and i want to implement type 2 slowlychanging dimensions where i have to insert and update same record.I created 2 jobs insert and update
I conditions :
1.Isnull or carrier name not equal then INSERT
2. UPDATE
. not is null(c0de) and if i have new data with same code and diff name
i have to expire by one day( routine ) old one and insert new one
3.update .
notis null(code) and carrier name equal.just update.
i am thinking of doing update first so that we can expire record and insert.
but it is not working .i want your idea
I ALSO WANT TO KNOW HOW CAN WE EQUATE INPUT.EXPDATE COLUMN ='9999-12-31'
I an new to datastage and i want to implement type 2 slowlychanging dimensions where i have to insert and update same record.I created 2 jobs insert and update
I conditions :
1.Isnull or carrier name not equal then INSERT
2. UPDATE
. not is null(c0de) and if i have new data with same code and diff name
i have to expire by one day( routine ) old one and insert new one
3.update .
notis null(code) and carrier name equal.just update.
i am thinking of doing update first so that we can expire record and insert.
but it is not working .i want your idea
I ALSO WANT TO KNOW HOW CAN WE EQUATE INPUT.EXPDATE COLUMN ='9999-12-31'