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
- 17772 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / venky
in target table u can write pre-sql statement as truncate
table tablename
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
What is the Rank index port in Rank transformation?
What do you understand by term role-playing dimension?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
design of staging area?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is confirmed fact in dataware housing?
Differences between connected and unconnected lookup?
what is informatica metadata?
How do you manage the Parameter files while migrating your data from one environment to another environment?
waht type of interface is used for testing the data in informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is exclusive and normal mode for repository services?
difference between repository database and repository service?
What are multi-group transformations?
