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
- 16059 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
Quickly characterize reusable change?
What is powercenter on grid?
what is mean by complex business rule ?
How to convert multiple rows to single row (multiple columns) in informatica
How to create Target definition for flat files?
Difference between Target-based loading and constraint-based loading?
my source is junk data how will u remove that junk data by using unix please any one replay me
How can we handle two sessions in informatica?
What are the types of caches in lookup? Explain them.
What do you understand by a term domain?
How can you increase the performance in joiner transformation?
How to call shell scripts from informatica?
How do you load unique records into one target table and duplicate records into a different target table?
How to load the data from people soft hrm to people soft erm using informatica?
What are roles and groups and benefits of using them?
