We are trying to load the delta data from a source SQL server table into a target SQL server table. The source table has a RowVersion (timestamp) column which is a binairy(8) data type.
To select the delta load of data, we first do a Max value of the timestamp column of the target table:
Then we store this value in a global variable with tFlowToIterate so we can use this in the select statement for the selection of records from the source.
Question: How can we do a SELECT-statement to compare binary values in the WHERE clause? It seems that binairy data is displayed in different ways:
- SQLserver: 0x00000000F0793D49
- Query builder in Talend: 00000000F0793D49
- System.out.println value in Talend: [B@42d3bd8b
Thanks on advance,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Pick up some tips and tricks with Context Variables
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs