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 is the procedure for creating independent data marts from informatica 7.1?
Why update strategy and union transformations are active?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the tasks that source qualifier perform?
What are the guidelines to be followed while using union transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between router and filter?
What is a snowflake schema?
What are the popular informatica products?
What is mapplet in informatica?
What are the prerequisite tasks to achieve the session partition?
What are mapplets?
4 yrs etl devloper roles and responsibilities?any body give solutions
Define the various join types of joiner transformation?