Load Ingest Data
Results 1 to 2 of 2

Thread: Using Global Transformation to Add Column with update date/time field

  1. #1
    DougW is offline US Technical Sales
    Join Date
    Aug 2006
    Location
    Northern California
    Posts
    20
    Rep Power
    0

    Using Global Transformation to Add Column with update date/time field

    Adding a column showing current date/time in either LOCAL time, or UTC time.


    1. Create a new Global Transformation of ‘Add Column’ type, and give it a meaningful name.
    Name:  8-22-2012 07-05-14.png
Views: 284
Size:  42.5 KB

    2. Select which schema and tables to apply transform to on the next step.

    Name:  8-22-2012 07-07-20.png
Views: 261
Size:  29.5 KB

    3. Create Transformation Rule, then save. Examples below show expressions for LOCAL and UTC time.
    • LOCAL TIME:

    Name:  8-21-2012 19-49-54.png
Views: 259
Size:  43.5 KB
    Expression:
    datetime('NOW','LOCALTIME')


    • UTC Time:

    Name:  8-21-2012 19-48-42.png
Views: 260
Size:  37.6 KB
    Expression:
    datetime()
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    vpnicholls is offline Junior Member
    Join Date
    Jun 2016
    Posts
    1
    Rep Power
    0

    What does this date represent?

    When using a timestamp in this way in a global transformation, what does this timestamp represent? Is it the time that record was written to the __ct change table? Or the target table itself? Or some other 'event'?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •