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 is lookup change?
Do you find any difficulty while working with flat files as source and target?
Explain your project of banking domian.
Name the different lookup cache(s)?
Mention some types of transformation?
What is session task and command task?
Explain why we use partitioning the session in informatica?
Explain the difference between mapping parameter and mapping variable?
How can we create index after completion of load process?
Where can we find the throughput option in informatica?
What is substr in informatica?
What are the new features of informatica 9.x developer?
Write the prerequisite tasks to achieve the session partition?
What is meant by a domain?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?