Interested to Buy Any Domain ? << Click Here >> for more details...
What is limitations of truncate and load option
- 1 Answers
- 9964 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
without table how to come first record only in oracle?
How can we remove the duplicates from flat file source?
What does cheating measurement mean?
What is a repository? And how to add it in an informatica client?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a predefined event?
What are Dimensional table?
How to open an older version of an object in the workspace?
What does reusable transformation mean?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the informatica workflow?
Mention few advantages of router transformation over filter transformation.
What are pre and post-session shell commands?
Write the advantages of partitioning a session?
