Hi,
Giving an example who my source and target should look like i can talk more about business rules later.
Thanks,
Bobby
Source:
OBJID BEGDA ENDDA SUBTY SOBID
10005822 10/16/2003 11/20/2008 A008 105404--- line 1 (Holder)
10005822 10/16/2003 3/31/2009 A999 105404 --- line 2 (Sub Holder)
10005822 6/23/2008 7/5/2009 A008 124530 --- line 3 (Holder)
10005822 11/21/2008 8/31/2009 A008 105404 --- line 4 (Holder)
10005822 8/31/2009 4/16/2010 A008 105323 --- line 5 (Holder)
10005822 4/19/2010 12/31/9999 A999 131995 --- line 6 (Sub Holder)
10005822 7/5/2010 12/31/9999 A008 131995 --- line 7 (Holder)
Always Match Holder with Sub Holder
Target:
POSITION_TCD POSI_HOLDER SUBS_OWNER EMP_ASSI_TYPE START_DT END_DT
10005822 105404 105404 Hold=Subs 10/16/2003 3/31/2009
10005822 124530 105404 HoldSubs 6/23/2008 3/31/2009
10005822 124530 No Substantive No Substan 4/1/2009 7/5/2009
10005822 105404 No Substantive No Substan 4/1/2009 8/31/2009
10005822 105323 No Substantive No Substan 8/31/2009 4/16/2010
10005822 No Holder No Substantive No Hold Substan 4/17/2010 4/19/2010
10005822 No Holder 131995 No Substan 4/20/2010 7/4/2010
10005822 131995 131995 Hold=Subs 7/5/2010 12/31/9999
Sir, I have read the project details clearly and am ready for it. I can assure you of perfection in my work and the work will be of high accuracy. Please provide more information about the project. Eagerly waiting for your reply. Thank you.
Sir, I have read the project details clearly and i know i can do it within time . Please give me the opportunity.
I am experience in oracle an pl/sql. currently working in a leading it company at back end.i am new to here but not new to oracle pl/sql. we are two friends working together.