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
Answer Posted / ravi
in the warehouse designer,in targets ,in generate and
execute option truncate the table
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What does cheating measurement mean?
Enlist the tasks for which source qualifier transformation is used.
What is workflow? What are the components of workflow manager?
In how many ways we can create ports?
What is the use of code page?
What are the types of lookup transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
what is unit testing?tell me proceedure
What is InformaticaPowerCenter?
What are the types of data warehouses?
How can one identify whether mapping is correct or not without connecting session?
How do you manage the Parameter files while migrating your data from one environment to another environment?
what is SDLC way of code development?
Which transformation is needed while using the Cobol sources as source definitions?
What is intricate mapping?