tIngresOutputBulk
Prepares the file whose data is inserted in bulk to the Ingres
DBMS for performance gain.
tIngresOutputBulk and tIngresBulkExec
are generally used together in a two step process. In the first step, an output file is
generated. In the second step, this file is used in the INSERT operation used to feed a
database. These two steps are fused together in the
tIngresOutputBulkExec component.
tIngresOutputBulk prepares a file with the schema
defined and the data coming from the preceding component.
tIngresOutputBulk Standard properties
These properties are used to configure tIngresOutputBulk running in the Standard Job framework.
The Standard
tIngresOutputBulk component belongs to the Databases family.
The component in this framework is generally available.
Basic settings
Property Type |
Either Built-in or |
|
Built-in: No property data stored |
|
Repository: Select the repository |
File Name |
Name of the file to be generated. Warning:
This file is generated on the local machine or a shared folder |
Append the File |
Select this check box to add the new rows at the end of the file. |
Schema and Edit |
A schema is a row description. It defines the number of fields (columns) to |
|
Built-In: You create and store the |
|
Repository: You have already created When the schema to be reused has default values that are integers or You can find more details about how to verify default |
Click Edit schema to make changes to the schema.
|
Advanced settings
Field Separator |
Character, string or regular expression to separate fields. |
Row Separator |
String (ex: ” |
Include Header |
Select this check box to include the column header in the |
Encoding |
List of encoding schemes. |
tStatCatcher Statistics |
Select this check box to collect log data at the component |
Global Variables
Global Variables |
NB_LINE: the number of rows processed. This is an After
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
Deployed along with tIngresBulkExec, tIngresOutputBulk is intended to save the incoming |
Limitation |
Due to license incompatibility, one or more JARs required to use this component are not |
Related scenarios
For related topics, see: