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
How to generate sequence numbers using expression transformation?
What is the cumulative sum and moving sum?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what are the deliverables?in your project?
How to Create a folder using pmrep command?
In informatica workflow manager, how many repositories can be created?
Can you generate sequence numbers without using the sequence generator transformation?
can u any challenge your project?
What is option by which we can run all the sessions in a batch simultaneously?
How to load the data from people soft hrm to people soft erm using informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain sessions and how many types of sessions are there?
Where are the source flat files kept before running the session?
What is session task and command task?
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.