Load Ingest Data
Results 1 to 3 of 3

Thread: Attunity Replicate - Table Filter - Last 6 months

  1. #1
    akisentia is offline Junior Member
    Join Date
    Jun 2018
    Posts
    2
    Rep Power
    0

    Attunity Replicate - Table Filter - Last 6 months

    Hi,
    I am trying to filter my source table (SQL Server).
    I wish to include records created in last month.
    My Record Selection Condition is as follows:
    $DateCreated>datetime('now','+1 MONTH')

    It parses fine in the the Expression Builder, but using SQL Server Profiler I can see that the condition does not appear in the record selection query, and all of the rows in the table are ending up in my target table.

    My source table column name is DateCreated which has datetime data type.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    293
    Rep Power
    5

  3. #3
    akisentia is offline Junior Member
    Join Date
    Jun 2018
    Posts
    2
    Rep Power
    0
    Thankyou,
    I think I was missing the distinction between Filter Conditions and Row Selection Conditions.
    It appears that Filter Conditions are applied to the source query when performing a full load and therefore handled by the source RDBMS, but Row Selection Conditions are handled in the Attunity process.
    Am I correct? If so is there any way to add a calculated condition in a Filter Condition?
    Thx.

Posting Permissions

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