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
- 18023 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 do u tune queries?
Explain lookup transformation source types in informatica
what is normalization? explain 1st NF, 2nd NF, 3rd NF
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is intricate mapping?
difference between source based commit? and target based commit? which is better with respect to performance?
without dynamic lookup transformation how to insert new rows and update existing rows?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Teradata 
