Component family |
Databases/Oracle |
|
Function |
tOracleSCDELT reflects and tracks |
|
Purpose |
tOracleSCDELT addresses Slowly |
|
Basic settings |
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 |
|
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 |
|
Connection type |
Drop-down list of available drivers:
Oracle OCI: Select this connection
Oracle Service Name: Select this
Oracle SID: Select this connection
Oracle Custom: Select this |
|
DB Version |
Select the Oracle version you are using. |
|
Host |
The IP address of the database server. |
|
Port |
Listening port number of database server. |
|
Database |
Name of the database |
|
Username and |
User authentication data for a dedicated database. To enter the password, click the […] button next to the |
|
Source table |
Name of the input DB2 SCD table. |
|
Table |
Name of the table to be written. Note that only one table can be |
|
Action on table |
Select to perform one of the following operations on the table
None: No action carried out on the
Drop and create table: The table is
Create table: A new table gets
Create table if not exists: A table
Clear table: The table content is
Truncate table: The table content |
|
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 |
|
Surrogate Key |
Select the surrogate key column from the list. |
|
Creation |
Select the method to be used for the surrogate key For more information regarding the creation methods, see SCD keys. |
|
Source Keys |
Select one or more columns to be used as keys, to ensure the |
|
Source fields value include Null |
Select this check box to allow the source columns to have Null NoteThe source columns here refer to the fields defined in the |
|
Use SCD Type 1 fields |
Use type 1 if tracking changes is not necessary. SCD Type 1 should |
|
Use SCD Type 2 fields |
Use type 2 if changes need to be tracked down. SCD Type 2 should
Start date: Adds a column to your
End Date: Adds a column to your SCD
Log Active Status: Adds a column to
Log versions: Adds a column to your |
Advanced settings |
Additional JDBC parameters |
Specify additional connection properties for the DB connection you |
|
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 |
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 an output component. It requires an |
For related topics, see tOracleSCD and tMysqlSCD.