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
- 18058 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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How can we remove the duplicates from flat file source?
How will the document be delivered to me?
What is informatica metadata and where is it stored?
What is an expression transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the meaning of up gradation of repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean by channel change?
What is the fact table?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
can we override a native sql query within informatica? How do we do it?
Which development components of informatica have the highest usage?
