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
- 18215 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 meant by active and passive transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to implement security measures using repository manager?
Mention few advantages of router transformation over filter transformation.
How to handle decimal places while importing a flatfile into informatica?
Repository user profiles
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between router and filter?
What are the mapping parameters and mapping variables?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are data-driven sessions?
What are the tasks that source qualifier perform?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to create Target definition for flat files?
What is resilience time?
