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
18011 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 aggregate cache in aggregator transformation?

1138

What are the different lookup cache(s)?

1113

What is meant by lookup transformation? Explain the types of lookup transformation?

943

What is the function of look up transformation?

1123

Explain incremental aggregation in informatica

1121

What is sequence generator transformation in informatica?

1071

What are the databases that informatica can connect to windows?

1044

Explain why we use partitioning the session in informatica?

1085

What is the way to execute pl/sql script using informatica mapping?

1596

What is decode in informatica?

1147

How to go to the older version for a mapping?

1093

Briefly define a session task?

1121

What is sorter transformation?

1039

Can we get 1st record through Informatica(without sequence number).

1472

Is there any way to read the ms excel datas directly into informatica?

1020