What is limitations of truncate and load option
Answer / 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 |
How can you access the remote source into your session?
How can you differentiate between powercenter and power map?
What are the tuning techniques you applied during your last project
how remove 1st 3 records & last 3 records in informatics
what are presession,postsession success and postsession failure commands ?
What is data merging, data cleansing and sampling?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is the incremental agrrigation?
what is the use of Java Transformation in Informatica 8.x?
Explain the etl program with few examples.
Explain dynamic target flat file name generation in informatica
What is the Difference between SetVariable and setmaxvariable in informatica?