in target table u can write pre-sql statement as truncate table tablename

Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.

Thanks
Abhishek

Question Posted / venky

5 Answers
18046 Views
CSC, I also Faced
E-Mail Answers

Answer Posted / venky

in target table u can write pre-sql statement as truncate
table tablename

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by pre and post session shell command?

1159

Can you use flat files in Mapplets.

2649

How can we update a record in the target table without using update strategy?

1145

Can we create multiple integration service on single repository?

1187

write a query to retrieve the latest records from the table sorted by version(scd)

1068

How do you set a varible in incremental aggregation

1891

What can we do to improve the performance of informatica aggregator transformation?

1094

What is source qualifier transformation in informatica?

1009

Explain lookup transformation is active in informatica

1104

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1078

Explain the mapping variable usage example in informatica

1157

What is informatica powercenter repository?

1201

In warehouses how many schemas are there?

1073

Mention some types of transformation?

1047

what are the deliverables?in your project?

2152