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 the fact table?
can we override a native sql query within informatica? Where do we do it?
What are the tasks that can be performed using sq?
What is olap (on-line analytical processing?
What are the components of workflow manager?
Define enterprise data warehousing?
How you can differentiate between connected lookup and unconnected lookup?
What is the format of informatica objects in a repository?
what is INFORMATICA TESTING process
Explain direct and indirect flat file loading (source file type) - informatica
what is size of u r database?
What is a difference between complete, stop and abort?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the conditions needed to improve the performance of informatica aggregator transformation?
how we can load rejected record's at run time?(not through bad files)