Any one tell me some 5 session failure in real time?And why
problem occur how to solve the issues?



Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?..

Answer / ali

if u config wrong relational coonnections in workflow manager, session failed.




2)if u enable bulk load without droping indexes in tgt table, run a session  the session get failed.




3)in workflow manager eventwait task waiting for particular time, then the indicator(file) not found, session get failed.




4)while sql override in s.q t/r,u miss any func in query, then (mapping valids) session failed? write  correct sql and execute it session succeess.




5)the tgt table has pk , but u r loading duplicated data  then session get failed( note:when u put 0 for "stop on errors" property it allows any number of non fatal errors)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

select count(1) from emp? what is the o/p?

5 Answers   TCS,


how i will stop my workflow after 10 errors

1 Answers   HP,


Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,


connected and unconnected lookups?

4 Answers  


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


How mapping parameter and variable works

1 Answers  


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,


How informatica recognizes mapping?

2 Answers   CTS,


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  


Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  


Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


Categories