What is limitations of truncate and load option
- 1 Answers
- 8834 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
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is mapping debugger?
r u done any partitions in ur project?
What is substr in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explian the Process of deployment groups in informatica
What is the difference between informatics 7x and 8x and what is latest version?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Design a mapping to load a target table with the following values from the above source?
Differences between version 7.x and 8.x.
What is event and what are the tasks related to it?
How to use pmcmd utility command?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Is there any way to read the ms excel datas directly into informatica?
