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 joiner transformation?
Enlist the various types of transformations.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Describe data concatenation?
What is sq transformation?
Why is sorter an active transformation?
Reusable transformation and shortcut differences
Which transformation is needed while using the Cobol sources as source definitions?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to do the error handling of if ur source is flatfiles?
Can we create two repositories on same database instance in oracle?
What are the types of caches in lookup?
What is data transformation manager process?
What is a predefined event?
What is the benefit of partitioning a session?