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
- 18085 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / sunil
Abhishek Bhai,
Possible Solution:-
1. While creating connection, use such a generic id, which
have all the permission on DB objects. This way you
definitely can play with your Target object.
2. If no such credential available then, Delete and commit
process can be implemented in pre-sql.. but process will
become very slow (depends on volume of data).
Cheers !
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is powercenter on grid?
What is the status code in stored procedure transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What is the sql query overwrite in source qualifier in informatica
How can informatica be used for an organization?
what is Active lock explain
What is joiner transformation?
How do you load only null records into target? Explain through mapping flow.
How many ways are there to create ports?
How to create the source and target database connections in server manager?
What is the reusable transformation?
What is the meaning of up gradation of repository?
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 ?
What are mapplets?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
