Table of Contents

Search

  1. About the Data Vault SQL Reference
  2. Introduction to SQL Reference for Informatica Data Vault
  3. Date and Time Arithmetic
  4. WHERE Clauses
  5. UNION Operator
  6. Parameterized Query
  7. Functions

Data Vault SQL Reference

Data Vault SQL Reference

Syntax

Syntax

  • Boolean value expression.
  • Direct Export parameter.
    A parameter that describes the Direct Export operation. Each parameter can be set only once in the SQL statement. The PATHS and FILEPREFIX parameters must be specified; all other parameters are optional. The parameters can appear in any order.
    The following table describes the Direct Export parameters:
Parameter
Description
PATHS
Is the list of computer/directory locations where the flat files will be written in round robin fashion. Multiple paths can be specified, separated by semicolons (
;
) or by new lines. The whole parameter value must be contained in single quotation marks (
' '
). Note that paths can have spaces, but if the last directory in the path ends with a space, terminate it with a slash or backslash
Each location must be accessible to all of the network computers running Data Vault Agent processes, otherwise the export operation will almost certainly fail.
FILEPREFIX (or FP)
Is the root name of the output flat file(s). Each flat file will be given the name
fileprefix
.
nnn
, where
nnn
is a number that increases incrementally with each new file from
000
to
NUMBEROFFILES-1
. The FILEPREFIX value must be contained in single quotation marks (
' '
).
NUMBEROFFILES (or NOF)
Is the number of flat files that will be created during the export (maximum:
1000
). Note that the size of each file will not necessarily be equal, as there are a number of factors influencing flat file size.
Default. the number of active Data Vault Agent processes, which excludes those Data Vault Agents dedicated to internal tasks
ESCAPE (or ESC)
Is the character used to "escape" the column delimiter, row delimiter, null character, or the escape character itself in the exported data. When the escape character immediately precedes one of those special characters, that character should be interpreted as part of the data. The escape character is a single character, defined in hexadecimal form, and contained in single quotation marks (
' '
). For example, the hexadecimal '\x5c' represents the backslash character "\".
Default is
\x1b
(the ESC character).
COLUMNDELIMITER (or CD)
Is the character that establishes column boundaries in the exported data. The column delimiter is a single character, defined in hexadecimal form, and contained in single quotation marks (
' '
).
Default is
\x1f
.
ROWDELIMITER (or RD)
Is the character that signifies the end of a row and the start of a new one in the exported data. The row delimiter is a single character, defined in hexadecimal form, and contained in single quotation marks (
' '
).
Default is
\x0a
(the linefeed character).
NULL
Is the character that represents a null value in the exported data. The null character is a single character, defined in hexadecimal form, and contained in single quotation marks (
' '
).
Default is
\x7f.

0 COMMENTS

We’d like to hear from you!