Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 18201 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / krishnakanth
If the informatia user id does not have permissions to
truncate the table in the database. Then there is no other
way we can truncate the table.
Anyways try with this option. Try to write a pre-sql
statement in the session. So that first the sql statement
will execute and then the session will start executing
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are ETL Tools?
What is a standalone command task?
What is a transaction control transformation?
What is an expression transformation?
What is meant by query override?
What are the tasks that can be performed using sq?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain why we use partitioning the session in informatica?
What is an active transformation?
How to elaborate powercenter integration service?
Differentiate between Load Manager and DTM?
What is a sorter transformation?
How identifying bottlenecks in various components of informatica and resolving them?
How to create a non-reusable instance of reusable transformations?
What are the guidelines to be followed while using union transformation?
