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
- 16063 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 is domain and gateway node?
How to configure mapping in informatica?
Have you worked with/created Parameter file
What is the use of source qualifier?
What is event and what are the tasks related to it?
Mention a few design and development best practices for informatica?
How to update or delete the rows in a target, which do not have key fields?
How we can use union transformation?
Explain pmcmd command usage in informatica
How to improve the performance of a session using sorter transformation?
What is main use of mapplet?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is incremental aggregation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
