Component family |
Databases/DB2 |
|
Function |
tDB2SCD reflects and tracks |
|
Purpose |
tDB2SCD addresses Slowly Changing |
|
Basic settings |
Use an existing connection |
Select this check box and in the Component List click the NoteWhen a Job contains the parent Job and the child Job, if you need to share an existing
For an example about how to share a database connection across Job levels, see |
|
Property type |
Either Built-in or Repository. Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: No property data stored |
|
|
Repository: Select the Repository |
|
Host |
Database server IP address. |
|
Port |
Listening port number of DB server. |
|
Database |
Name of the database. |
|
Table Schema |
Name of the DB schema. |
|
Username and |
DB user authentication data. To enter the password, click the […] button next to the |
|
Table |
Name of the table to be written. Note that only one table can be |
|
Schema and Edit |
A schema is a row description. It defines the number of fields to be processed and passed on Since version 5.6, both the Built-In mode and the Repository mode are Click Edit schema to make changes to the schema. If the
|
|
|
Built-in: The schema is created |
|
|
Repository: The schema already |
|
SCD Editor |
The SCD editor helps to build and configure the data flow for For more information, see SCD management methodologies. |
|
Use memory saving Mode |
Select this check box to maximize system performance. |
|
Die on error |
This check box is cleared by default, meaning to skip the row on |
Advanced settings |
Additional JDBC parameters |
Specify additional connection properties for the DB connection you NoteYou can set the encoding parameters through this field. |
|
End date time details |
Specify the time value of the SCD end date time setting in the This field appears only when SCD Type |
|
Debug mode |
Select this check box to display each step during processing |
|
tStatCatcher Statistics |
Select this check box to collect log data at the component |
Dynamic settings |
Click the [+] button to add a row in the table and fill The Dynamic settings table is available only when the For more information on Dynamic settings and context |
|
Global Variables |
NB_LINE_UPDATED: the number of rows updated. This is an
NB_LINE_INSERTED: the number of rows inserted. This is an
NB_LINE_REJECTED: the number of rows rejected. This is an 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 Talend Studio |
|
Usage |
This component is used as Output component. It requires an Input |
|
Limitation |
This component requires installation of its related jar files. For more information about the |
For related topics, see tMysqlSCD.