CSV

Delimiter

Required

Specify the one character string used to separate fields in the file.

{comma,pipe,dash,semicolon,space,tab_char}

Default Value: comma

Skip Initial Space

Required

Select True, if the whitespace immediately following the delimiter is to be ignored, else No.

{Yes,No}

Default Value: No

Line Terminator

Required

Specify the string used to terminate text

String value (eg:/r/n)

Default Value: /r/n

Quote Character

Required

Specify the one character string used to quote fields

String value (eg:")

Default Value: "

Escape Character

Required

Removes any special meaning from the following character. The default value None disables escaping

String value (eg:None)

Default Value: None

Double Quote

Required

Controls how instances of Quote character appearing inside a field should themselves be quoted. When Yes, the character is doubled. When No, the Escape character is used as a prefix to the Quote character.

{Yes,No}

Default Value: Yes

Quoting

Required

Specify the type of Quoting : QUOTE_ALL instructs writer objects to quote all fields, QUOTE_MINIMAL instructs writer objects to only quote those fields which contain special characters such as delimiter, quote character or any of the characters in line terminator, QUOTE_NONNUMERIC instructs writer objects to quote all non-numeric fields and reader to convert all non-quoted fields to type float, QUOTE_NONE Instructs writer objects to never quote fields.

{quote_minimal,quote_none,quote_all,quote_nonnumeric}

Default Value: quote_minimal

Attempt Schema Inference

Required

If Yes then value types will be fetched as it is, eg: Float will be fetched as float. If No then everything will be fetched as string irrespective of its type.

{Yes,No}

Default Value: No

Insert Mode

Required

Specifies the manner in which data will get updated in the data warehouse : UPSERT will insert only new records or records with changes, APPEND will insert all fetched data at the end, REPLACE will drop the existing table and recreate a fresh one on each run.

{Upsert,Append,Replace}

Default Value: UPSERT

DataSet Name

Required

Enter the DataSet Name

String value

DataSet Description

Optional

Enter a brief description about the DataSet here

String value