Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

D s item
itemData Type
SQL DW Data TypeNotes
StringVARCHAR 
IntegerBIGINT
Info

NOTE: The

D s platform
may infer Integer columns containing very large or very small values as String data type. Before you publish, you should verify that your columns containing extreme values are interpreted as Integer type.You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of Target Matching.

FloatFLOAT 
BoolBIT 
DatetimeDATETIME2If a time-only value is published as an append to a pre-defined DATETIME2 column, then the output column is prepended with 1900-01-01.
Datetime (with time value only)TIME

If a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output.

Info

NOTE: The platform publishes to Timestamp columns only for append operations to pre-existing tables.


DatetimeVARCHAR

If a Datetime value is published as an append to a pre-defined VARCHAR column, then the output column contains the string value of whatever appears in the Transformer page.

When you publish results from a job through the Export Results window to SQL DW, all Datetime column values are written as String type.

MapVARCHAR 
ArrayVARCHAR 
DateVARCHAR 
All Other Data TypesVARCHAR 

Append to existing table

...

If you are publishing to a pre-existing table, the following data type conversions apply:

  • Columns: 
    D s item
    itemdata types
  • Rows: Target table data types

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

 StringIntegerDatetimeBoolFloatMapArray
VARCHARYYYYYYY
NVARCHARYYYYYYY
CHARYYYYYYY
NCHARYYYYYYY
TINYINT       
SMALLINT       
INT       
BIGINT Y     
DATETIME2  Y    
TIME  Y    
BIT   Y   
FLOAT Y  Y  
REAL Y  Y  
DECIMAL Y  Y