[resolved] Truncate table from job design

[Anonymous]

Hi ALL,
I just wonder, how do i wants to truncate table from job design? My plan is, i wants to truncate all data from table A before i load the new fresh data into it.

Plz help me.....thanks in advance

[Anonymous]

Hi
Just use txxxRow component to execute a truncate statement to truncate the table before loading new data.
Shong

[Anonymous]

Hi,
I wanted to try truncate the table by using txxxRow, but i can see it only can cater for one-by-one table. I wanted to truncate more than one table. How was it?

Regards,

[Anonymous · Accepted solution]

Hi,
Think selecting the Action on Table as Truncate and leaving the Action on Data as Insert would help on the tXXXOutput component.
cheers

[Anonymous]

Hi,
I wanted to try truncate the table by using txxxRow, but i can see it only can cater for one-by-one table. I wanted to truncate more than one table. How was it?

Regards,

If the tables' name which you want to truncate are in a file, you can read this file, then iterate each table name and pass it to tOracleRow one by one. If the tables are in a same database, use tTableList to iterate each table and pass it to tOracleRow one by one.
Shong

[Anonymous]

Hi pravinkumarbandi,
Thanks for your idea. I've tested and indeed it worked.

Hi Shong,
I try to apply your ideas but i didn't really get
Appreciate if you can give any screen shots for both method.

Regards

[Anonymous]

Hi
I take an example to explain how to use tOracleTableList to iterate each table and truncate it one by one on tOracleRow.
Shong