沉睡森林@漂在北京

          本處文章除注明“轉(zhuǎn)載”外均為原創(chuàng),轉(zhuǎn)載請注明出處。

            BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
            152 隨筆 :: 4 文章 :: 114 評論 :: 0 Trackbacks
          最近一直沒有文章,今天發(fā)一點(diǎn)在工作中遇到的問題。主要是oracle的etl產(chǎn)品odi的相關(guān)問題,在OTN論壇上面很快找到了答案。下面抄錄論壇里面的發(fā)帖和回復(fù),減少我打字的數(shù)量。

          Hi,

          I have two tables with same structure. Now I want to union the data from these two table and load the result in target table. How can I achieve this functionality in ODI? In formatica this can be done using UNION Transformation but I don't know about ODI. 
          Please help.

          Thanks,
          Monika


          Hi Monika,

          Union transformation cannot be done by Interface in ODI.

          There are three option in ODI to achieve your task

          1) you need to create two interfaces like int1 and int2
          where int1 will transfer the data from tab1(source) to target table and int2 will transfer the tab2(source) to target table.

          2) In second option, create a view for the union of tab1 and tab2 and use that view as source in the interafce to tranfer the union data to target. In this method we can achive this by single interface.

          3) create the ODI procedure with a sql query of insert into target_table (select * from tab1 union select * from tab2).

          Thanks,
          Madha.
          posted on 2009-05-21 14:25 王總兵 閱讀(259) 評論(0)  編輯  收藏 所屬分類: DataBase
          主站蜘蛛池模板: 花莲市| 府谷县| 车致| 施秉县| 砚山县| 泰宁县| 台东县| 洮南市| 阿荣旗| 墨玉县| 凤阳县| 南漳县| 宝丰县| 盐山县| 邢台市| 岳阳县| 泾阳县| 红河县| 中方县| 嘉定区| 赣州市| 济源市| 柳江县| 长宁县| 尤溪县| 扎赉特旗| 丹东市| 潞西市| 东至县| 麻栗坡县| 太仓市| 六枝特区| 文水县| 绵阳市| 玛曲县| 武川县| 长宁区| 庄河市| 梅河口市| 定安县| 略阳县|