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 / 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
What is the meaning of decode in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
What is meant by lookup transformation?
what are 3 tech challenges/ common issues you face?
What are mapplets? How is it different from a Reusable Transformation?
What is workflow manager?
What is flashback table ? Advance thanks
Please let me know how to make Data masking in informatica..
Explain about cumulative Sum or moving sum?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to join three sources using joiner? Explain though mapping flow.
What is joiner transformation in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain in detail scd type 2 through mapping.
What is the use of source qualifier?