the scenario is given below plz help how to find the end_d
Posted: Fri Nov 23, 2007 3:46 am
Based on the effective date I aam sorting the records based on descending
No Name bank flag Eff_d End_d
1 aaa city Y 2007-11-22 9999-12-31
1 aaa hdfc N 2007-11-19 9999-12-31
1 aaa icici N 2007-11-18 9999-12-31
Based on this I wnt to derive END_DATE based on the effective date of the prevous records when ever the sourgate key column(No) is same
The target data should be like this:: target also db2
No name bank flag EFF-d End_d
1 aaa city Y 2007-11-22 9999-12-31
1 aaa hdfc N 2007-11-19 2007-11-22
1 aaa icici N 2007-11-18 2007-11-19
this is the problem currently i am facing anybody having any idea of this please reply to me.that was very helpful to me
Reagrds
No Name bank flag Eff_d End_d
1 aaa city Y 2007-11-22 9999-12-31
1 aaa hdfc N 2007-11-19 9999-12-31
1 aaa icici N 2007-11-18 9999-12-31
Based on this I wnt to derive END_DATE based on the effective date of the prevous records when ever the sourgate key column(No) is same
The target data should be like this:: target also db2
No name bank flag EFF-d End_d
1 aaa city Y 2007-11-22 9999-12-31
1 aaa hdfc N 2007-11-19 2007-11-22
1 aaa icici N 2007-11-18 2007-11-19
this is the problem currently i am facing anybody having any idea of this please reply to me.that was very helpful to me
Reagrds