Pages

Sunday, March 17, 2013

From the order_delivery table insert the records to target where , day difference between order_date and delivery_date is greater than 2 days. ( Note: see last article , where we discussed finding the time in hour between two dates)


Source
ORDER_NO    ORDER_DATE       DELIVERY_DATE
---------                      ---------                   ---------
        2                        11-JAN-83               13-JAN-83
        3                        04-FEB-83               07-FEB-83
        1                        08-DEC-81              09-DEC-81

Target
 ORDER_NO    ORDER_DATE   DELIVERY_ DATE  
 ---------             -------- ------    --- ----------
  2                      11-JAN-83       13-JAN-83       
  3                      04-FEB-83       07-FEB-83  
These are the steps for achieving this scenario
  1. Connect all the rows from SQF to update strategy transformation.
  2. In update strategy properties write the expression like this
  3. Finally send to target.

No comments:

Post a Comment