What is limitations of truncate and load option



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

Post New Answer

More Informatica Interview Questions

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  


Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,


How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  


Explain the flow of data in Iinformatica?

1 Answers  


how much memory (size) occupied by a session at runtime

4 Answers   Wipro,






Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


what is the exact meaning of domain?

3 Answers  


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


what is unit testing?tell me proceedure

0 Answers   L&T, UST,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


Implementation methodology

0 Answers  


Categories