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
- 18197 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
pmscmd startworkflow -sv
How do you convert single row from source into three rows into target?
Can you generate sequence numbers without using the sequence generator transformation?
What are the issues you have faced in your project? How did you overcome those issues?
what is the difference between informatica6.1 and infomatica7.1
What is difference between a gateway node and worker node?
How to load the data from a flat file into the target where the source flat file name changes daily?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What do you mean by blocking transformation?
What is native users?
Clarify the aggregator change?
What is sorter transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain informatica architecture - version 8 / 9
What is informatica?
