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
- 16080 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 |
How to handle changing source file counts in a mapping?
how to get max value record into one target and remaining records into another target?
what is the difference between lookupoveride and joiner?
How do you load only null records into target? Explain through mapping flow.
how u know when to use a static cache and dynamic cache in lookup transformation.
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
My source table having some records ,i want load 1st record and last record into one target?
In how many ways we can create ports?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How can you validate all mappings in the repository simultaneously?
What does command task mean?
why dimenstion tables are denormalized in nature ?
Teradata 
