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 is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  


What are the new features in Informatica 5.0?

1 Answers  


checkout and checkin in informatica 8.6

3 Answers   TCS,


What is the different lookup cache(s)?

0 Answers  






what are the deliverables?in your project?

0 Answers   DELL,


What is powercenter on grid?

0 Answers  


What is the default join that source qualifier provides?

3 Answers   Informatica,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


What is InformaticaPowerCenter?

0 Answers   Informatica,


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


Categories