Hai,


   I have to maintained data Primary Key Based,(Ie,TR_id),i have additionally two columns in createddate,updateddate column

   In this two columns scd1 process based,if New rows means createddate column  generates date,existing rows mean generate values in updatedcolumn only date value


  ex:   source
                 
  tr_id  sal
101    40
110    90
101    11

ex: output
                                               

tr_id sal createddate updateddate

  101  11 2009-03-28  2009-03-30
  110  90  2009-03-30  null



  Once comes New TR_id  row Generate systemdate in createddate column, If comes again old rows generate systemdata in updatedcolimn,

How will do this in this scenario?