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
- 17773 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishnakanth
If the informatia user id does not have permissions to
truncate the table in the database. Then there is no other
way we can truncate the table.
Anyways try with this option. Try to write a pre-sql
statement in the session. So that first the sql statement
will execute and then the session will start executing
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / venky
in target table u can write pre-sql statement as truncate
table tablename
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi
in the warehouse designer,in targets ,in generate and
execute option truncate the table
| Is This Answer Correct ? | 0 Yes | 3 No |
when we use dynamic lookup,if condition matches what will be the o/p?
Diffrence between static and dynamic cache
why we use stored procedure transformation?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
how remove 1st 3 records & last 3 records in informatics
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What are differences between Informatica 7.1 and 6.1
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
Whats there in global repository
What is parallel processing in informatica?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
Teradata 
