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

what are the difference between Informatica 7.1 and 8.1?

6 Answers  


What are the prerequisite tasks to achieve the session partition?

0 Answers  


If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  






when we dont use aggregator in mapping ?

2 Answers   CSC,


What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  


What is an expression transformation in informatica?

0 Answers  


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


Explain factlessfact table with scenario

1 Answers   HCL,


what is work of PUSH DOWN option

2 Answers   Wipro,


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


Categories