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
- 18059 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / raj
Use delete * .... in pre-sql
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is expression transformation?
How an expression transformation differs from aggregator transformation?
How can you increase the performance in joiner transformation?
Does an informatica transformation support only aggregate expressions?
What is native users?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Write the program through which the records can be updated?
What is DR strategy for Informatica project?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Is stop and abort are same in informatica?
what are the Methods For Creating Reusable Transformations?
What do mean by local and global repository?
Different sorts of metadata that stores in the storage facility?
Which means the first record should come as last record and last record should come as first record and load into the target file?
