Interested to Buy Any Domain ? << Click Here >> for more details...
What is limitations of truncate and load option
- 1 Answers
- 9956 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? How do we do it?
What are the restrictions of union transformation?
How many transformations can be used in mapplets.
Name the different lookup cache(s)?
What are the different types of repositories created using informatica?
what is the hint? how to use it to reduce the query processing in program?
Have you worked with/created Parameter file
What is an active transformation?
Enlist the various types of transformations.
What are the static cache and dynamic cache in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the cumulative sum and moving sum?
When do you use sql override in a lookup transformation?
How do you promote a non-reusable transformation to reusable transformation?
How to generate sequence numbers?
