If could first create appropriate table,then import data

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

same title,
If INFA could first create relevant table and then insert data when target table do not exist?
If so, that would be perfect!
Thanks a lot

You can create a target table using a create table statement in a Pre-SQL command portion of the target definition.

The session performs the following operations in this order:

Connects to the target database.

Runs the Pre-SQL command (creating the target table).

Loads the data into the target table.

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

Thank you,
but my also want to create target table which depend on source table dynamic,
Please see http://www.mydwbi.com/posts/list/241.page#1274
Any idea?

这篇文章被编辑了 1 次. 最近一次更新是在 2008-07-15 21:23:37

First of all, you need to define the target in INFA, so it's not so dynamic.
You can define the target base on source, generate the sql in INFA target tab and do what lynx286 has mentioned.
I think this apporach can meet your needs.