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 / 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 |
Post New Answer View All Answers
How to Create a folder using pmrep command?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How are indexes created after completing the load process?
What is a surrogate key?
What is the sequence generator transformation in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is enterprise data warehousing?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the prerequisite tasks to achieve the session partition?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
pmscmd startworkflow -sv
How many input parameters can exist in an unconnected lookup?
Differentiate between a database and data warehouse?
What is an expression transformation in informatica?
Target increases every day even though no new record was inserted