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
- 18057 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
Name the different lookup cache(s)?
How would you copy the content of one repository to another repository?
What is sorter transformation?
Difference between Data and Index Caches?
What is powercenter on grid?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the mapping parameters and mapping variables?
What are the features of complex mapping?
What are active and passive transformations?
how to load rows into fact table in data warehouse
Informatica settings are available in which file?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can you differentiate between powercenter and power map?
waht type of interface is used for testing the data in informatica
What do you mean by channel change?
