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
- 17763 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
wat are deployement groups in informatica, how it will be used for developers
update strategy transformation in informatica
What is a dimensional model?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the types of caches in lookup?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What you know about transaction control transformation?
Explain dynamic target flat file name generation in informatica
How to extract sap data using informatica? What is abap? What are idocs?
Difference between Data and Index Caches?
Explain the shared cache and re-cache?
Which version configuration tool used in ur project?
What is data movement mode in Informatica and difference between them?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is session task and command task?
