How can I achive this?
Posted: Wed Jul 23, 2008 2:03 pm
My scenario is like this:
For each input record, the process should examine to see if there are any prior records for that member. If there is an existing record then that record END_DT should be update with current record IC_DT.
For example, 3 source records for a member could be
Rec1 --> IC_DT=1/1/2006
Rec2 --> IC_DT=1/1/2007
Rec3 --> IC_DT=1/1/2008
These would become three Target records with:
Rec1 --> EFF_DT=1/1/2006, END_DT=1/1/2007
Rec2 --> EFF_DT=1/1/2007, END_DT=1/1/2008
Rec3 --> EFF_DT=1/1/2008, END_DT=12/31/9999 (Default date)
Please suggest me a way to get this.
Thanks in advance.
For each input record, the process should examine to see if there are any prior records for that member. If there is an existing record then that record END_DT should be update with current record IC_DT.
For example, 3 source records for a member could be
Rec1 --> IC_DT=1/1/2006
Rec2 --> IC_DT=1/1/2007
Rec3 --> IC_DT=1/1/2008
These would become three Target records with:
Rec1 --> EFF_DT=1/1/2006, END_DT=1/1/2007
Rec2 --> EFF_DT=1/1/2007, END_DT=1/1/2008
Rec3 --> EFF_DT=1/1/2008, END_DT=12/31/9999 (Default date)
Please suggest me a way to get this.
Thanks in advance.