沉睡森林@漂在北京

本处文章除注明“转载”外均为原创,转载请注明出处。

  BlogJava :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 管理 ::
  152 随笔 :: 4 文章 :: 114 评论 :: 0 Trackbacks
最近一直没有文章,今天发一点在工作中遇到的问题。主要是oracle的etl产品odi的相关问题,在OTN论坛上面很快找到了答案。下面抄录论坛里面的发帖和回复,减少我打字的数量。

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 王总兵 阅读(168) 评论(0)  编辑  收藏 所属分类: DataBase

只有注册用户登录后才能发表评论。


网站导航: