tOracleOutputBulk
Writes a file with columns based on the defined delimiter and the Oracle
standards.
The tOracleOutputBulk and tOracleBulkExec components are 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 tOracleOutputBulkExec component,
detailed in a separate section. The advantage of using two separate steps is that the
data can be transformed before it is loaded in the database.
tOracleOutputBulk Standard properties
These properties are used to configure tOracleOutputBulk running in the Standard Job framework.
The Standard
tOracleOutputBulk component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Property type |
Either Built-in or Repository |
 |
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 |
Select this check box to add the new rows at the end of the |
Schema and Edit |
A schema is a row description, it defines the number of fields to be processed and Click Edit
|
 |
Built-In: You create and store the schema locally for this component |
 |
Repository: You have already created the schema and stored it in the When the schema to be reused has default values that are You can find more details about how to |
Advanced settings
Advanced separator (for number) |
Select this check box to change data separators for
Thousands separator: define
Decimal separator: define |
Field separator |
Character, string or regular expression to separate fields. |
Row separator |
String (ex: ” |
Encoding |
Select the encoding from the list or select Custom and define it |
Bulk file parameters |
Set the parameters Buffer Size |
tStatCatcher Statistics |
Select this check box to gather the job processing metadata at a |
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 |
This component is to be used along with tOracleBulkExec component. Used together they offer |
Component family |
Databases/Oracle |
Related scenarios
For use cases in relation with tOracleOutputBulk, see
the following scenarios: