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
- 18212 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / venky
in target table u can write pre-sql statement as truncate
table tablename
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How big was your fact table
What is olap (on-line analytical processing?
Explain the code page compatibility?
How can we remove the duplicates from flat file source?
What does reusable transformation mean?
waht type of interface is used for testing the data in informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is mean by complex business rule ?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you mean incremental aggregation?
What is meant by lookup transformation? Explain the types of lookup transformation?
How do you handle two sessions in Informatica
What are the components of Informatica? And what is the purpose of each?
how tokens will generate?
Briefly explain the aggregator transformation?
