How to Loop and get dynamic info?

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

How can I Loop and deal with those tables whose name was defined in one main table?
Any idea? Thanks

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

Source需要动态从一张表中取得，
SSIS可以使用For Each组件实现，PC该怎么做呢？
谢谢

初级会员 注册时间: 2008-07-04 04:35:31 文章: 10 离线

suggest you use store proce transformations

to get dynamic table names

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

bi51 wrote:suggest you use store proce transformations

to get dynamic table names

yes, stored proc transformations could get dynamic table name,
but could not satisfy my this needs,
I also need to loop those table to do something

初级会员 注册时间: 2008-07-02 00:56:01 文章: 7 离线

关注中

先做一个表的设计作为模板，导出xml。写程序，批量生成xml 然后在导入。

版主 注册时间: 2008-05-08 20:35:45 文章: 25 来自: 闪奥兰星 离线

1. 建一控制表，保存要循环处理的表名以及标识符'N'或者'Y'表示处理与否
2. 在Mapping Level定义parameter $$table_name,在Workflow Level定义parameter $table_ind
3. 用shell或者INFA mapping生成parameter file,分别给$$table_name,$$table_ind赋值,只取'N'的行,每次那一行
[global]
$$table_name=XXXX
$table_ind=N
4. 在mapping里,source qualifier用sql overwrite,表名用参数$$table_name
5. workflow里link上判断$table_ind是不是N,N的话执行mapping对应的session,否则不执行，loaded完数据更新控制表相应的到'Y'
在session的后从command调这个workflow，模拟循环

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

Thanks in Advance, Go on
Because my target table's name depend on the source table name, actually same name different schema name
I hope INFA could first create the relevant target table before import data rather than creating target table in manully at the start
If it is possible for INFA?
Thanks

版主 注册时间: 2008-05-08 20:35:45 文章: 25 来自: 闪奥兰星 离线

please refer to http://www.mydwbi.com/posts/list/254.page

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

Generating create table.sql is pretty cool,but that will make Loop dynamic source table nonsense
Thanks a lot

版主 注册时间: 2008-05-08 20:35:45 文章: 25 来自: 闪奥兰星 离线

In INFA, the very beginning of your work is to define the source and target, could you re-evaluate your requirement and what INFA can do?