<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                # Informatica 中的事務控制轉換:TCL 命令 > 原文: [https://www.guru99.com/transaction-control-transformation-informatica.html](https://www.guru99.com/transaction-control-transformation-informatica.html) #### 什么是事務控制轉換? 事務控制是一種主動的關聯轉換,它使我們能夠在執行映射期間提交或回滾事務。 提交和回滾操作非常重要,因為它可以保證數據的可用性。 當處理大量數據時,可能存在將數據提交給目標的情況。 如果提交的執行頻率太高,那么這將是系統的開銷。 如果提交執行得太晚,則在失敗的情況下,有丟失數據的機會。 因此,為了提供靈活性,提供了事務控制轉換。 ## TCL COMMIT & ROLLBACK 命令 此轉換中有五個可用的內置變量來處理操作。 ``` TC_CONTINUE_TRANSACTION ``` In tc_continue_transaction there are no operations performed, the process of data load continues as it is. ``` TC_COMMIT_BEFORE ``` In tc_commit_before when this flag is found set, a commit is performed before the processing of current row. ``` TC_COMMIT_AFTER ``` In tc_commit_after the current row is processed then a commit is performed. ``` TC_ROLLBACK_BEFORE ``` In tc_rollback_before, rollback is performed first then data is processed to write. ``` TC_ROLLBACK_AFTER ``` In tc_rollback_after data is processed then the rollback is performed. ## 例: 在此示例中,當找到 dept no = 20 條件為 true 時,我們將向目標提交數據 **步驟 1** –創建一個映射,其中 EMP 為源,EMP_TARGET 為目標 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/db/17/db176b31d259540d54b662e8950dcddd_1330x688.png "Transaction Control Transformation in Informatica") **步驟 2** –使用轉換菜單創建一個新轉換,然后 1. 選擇一個事務控件作為新的轉換 2. 輸入轉換名稱“ tc_commit_dept20” 3. 選擇創建選項 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/83/38/8338ac93c621f6868c83e270218606c4_396x211.png "Transaction Control Transformation in Informatica") **步驟 3** –將創建事務控制轉換,選擇完成按鈕 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/cf/77/cf77eeb6381086c3c2ef9f32c8e41ab9_781x467.png "Transaction Control Transformation in Informatica") **步驟 4** -將所有列從源限定符拖放到事務控制轉換,然后將所有列從事務控制轉換鏈接到目標表 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/11/be/11be33271287c10a080fce90e21cbff3_1123x437.png "Transaction Control Transformation in Informatica") **步驟 5** –雙擊事務控制轉換,然后在“編輯屬性”窗口中 1. 選擇屬性選項卡 2. 單擊事務控制編輯器圖標 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/ff/5b/ff5be5d0f71d33180cb29965efff5d05_791x568.png "Transaction Control Transformation in Informatica") **步驟 6** –在表達式編輯器中輸入表達式– **“** iif(deptno = 20,tc_commit_before,tc_continue_transaction)”,然后選擇確定 這意味著如果找到 deptno 20,則在目標中提交事務,否則繼續當前處理。 ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/b6/e6/b6e6fb031c543316aaf75f05b6230419_1009x428.png "Transaction Control Transformation in Informatica") **步驟 7** –在上一個窗口中選擇“確定” ![Transaction Control Transformation in Informatica with EXAMPLE](https://img.kancloud.cn/94/48/9448173dac2f995f1c86e7027a2e186a_791x568.png "Transaction Control Transformation in Informatica") 現在,保存映射并在創建會話和工作流之后執行它。 只要在數據中找到部門編號 20,此映射就會將數據提交給目標。
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看