What is limitations of truncate and load option
Answer Posted / abhinaw prakash
You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What if the source is a flat-file?
Is stop and abort are same in informatica?
What is the difference between a repository server and a powerhouse?
Under which circumstances, informatica server creates reject files?
What is Cognos script editor?
What are the different types of transformation available in informatica.
How might you approve all mappings in the archive all the while?
What is a repository? And how to add it in an informatica client?
What are the components of Informatica? And what is the purpose of each?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is sorter transformation?
What is informatica? Why do we need it?
Performance tuning( what you did in performance tuning)
What does “tail –f” command do and what is its use as an Informatica admin.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.