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 / raj
Use delete * .... in pre-sql
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica?
what is mean by complex business rule ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain why we use partitioning the session in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Sequence generator, when you move from develoment to production how will you reset
Performance tuning in UNIX for informatica mappings?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to use pmcmd utility command?
Difference between Target-based loading and constraint-based loading?
How big was your fact table
What do you mean by worklet?