多表查询表达式副本? [英] Multiple tables query expression copy?

问题描述

 

我看到了多个表副本的ADF示例，这些示例在内部使用Foreach组件.
就我而言，需要通过查询体验复制多个基于条件的表到相应的目标表，而不是创建多副本组件.

例如，当我在复制向导-用户查询页面中输入以下2条查询时，它正在处理具有单个目标表而不是2个表的单个自定义查询.

选择empno，从emp修改engt； '01/01/2018';
选择offno，office的办公室改名，> '01/04/2018';

解决方案

是的，在复制向导中，当您输入自定义查询时，它将对您选择的单个表做出反应.

如前所述，您可以使用 在ADFv2中进行foreach 活动，构造一个 items 数组来存储您的自定义查询，并在 foreach 在 items 数组上进行迭代的活动.

希望会有所帮助.谢谢.

 

i have seen the ADF examples of multiple table copy, which internally using Foreach component. 
In my case, Need to copy the multiple condition based tables through query experission  to corresponding target tables,  instead of creating the multiple copy component. 

For example, when i input below 2 queries in copy wizard - User query page, it's treating  single custom query with single destination table not 2 tables.

select empno, enam from emp where modifiedon > '01/01/2018';
select offno, offname from office where modifiedon > '01/04/2018';

解决方案

Hi,

Yes, in copy wizard, when you input a custom query, it reacts on the single table you selected.

As you mentioned, in your case you could use a foreach activity in ADFv2, construct an items array storing your custom queries and involves a copy activity in foreach activity to iterate on the items array.

Hope it'll help. Thanks. 

这篇关于多表查询表达式副本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！