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
- 18024 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 are the guidelines to be followed while using union transformation?
Partition, what happens if the specified key range is shorter and longer
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
update strategy transformation in informatica
Difference between Target-based loading and constraint-based loading?
Explain the informatica workflow?
Write the unconnected lookup syntax?
What is the function of look up transformation?
How can you validate all mappings in the repository simultaneously?
Differences between connected and unconnected lookup?
what are 3 tech challenges/ common issues you face?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Describe an informatica powercenter?
What is enterprise data warehousing?
What is a stored procedure transformation?
