Note:
You may want to associate data read from a real-time input source with data from another database, and then write data into a database in real time.
You can configure a real-time task in FineDataLink to read data from dimensional data sources using the Dimension Table Input operator and from real-time data sources, associate the read data using Data Association, and write data into databases in real time.
The target table does not reflect real-time data changes in the dimension table. Updates only occur when data in CDC Input changes and joins with the latest data in the dimension table.
You can select the required data connection. For details about how to create and manage data connections, see Data Connection Creation and Management.
For details about databases supported by DB Table Input in Scheduled Task, see Data Sources Supported by FineDataLink (Basic Data Source and Big Data in Progressive Data Source in the "Types of Data Sources Supported by Scheduled Task" section).
Dimension Table Input cannot be used as an input source alone to output data. It must be followed by a Data Association operator with real-time data input.
You cannot connect two real-time data sources using Data Association.
You cannot connect two Dimension Table Input operators using Data Association.
You can only connect one real-time data source and one or multiple Dimension Table Input operators using Data Association.
Left Table:
When you associate a real-time data source with a dimension table, the left table must be the real-time data source.
When joining multiple dimension tables, start by associating the real-time data source (as the left table) with one dimension table, then use the resulting dataset to join other dimension tables sequentially.
Join methods include Left Join, Right Join, Inner Join, and Full Outer Join.
When associating a real-time data source with a dimension table, you can only select Left Join or Inner Join.
Right Table:
The right table can only be a dimension table.
Join Field:
You can configure multiple join fields in Association Setting.
You can select any field from the left table.
Four join methods are supported, which are identical to those in Data Association in scheduled tasks. For details, see Data Association.
This section takes associating data from a real-time input source with data from another database and then writing data into a database as an example.
Log in to FineDataLink, choose Data Development > Real-Time Task, and create a real-time task, as shown in the following figure.
Drag a Dimension Table Input operator onto the editing page, and select the data source and the source table, as shown in the following figure.
Click Data Preview to view the fetched data, as shown in the following figure.
Drag a real-time data input operator onto the page (for example, CDC Input), and set Data Source, Source Table, Read Mode, and Synchronization Type, as shown in the following figure.
Add a Data Association operator and configure the join method and the join field, as shown in the following figure.
Click Data Preview to preview the join result, as shown in the following figure.
Output the data after real-time processing to a specified database, as shown in the following figure.
For details about the configuration of DB Table Output, see DB Table Output (Real-Time Task).
Click Start to start the real-time task, as shown in the following figure.
The task running status is displayed, as shown in the following figure.
The result of the first synchronization is displayed in Log.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy