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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How many dimensions are there in informatica?

636


How does a sorter cache works?

582


What do you understand by term role-playing dimension?

592


What do you mean by channel change?

558


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1216






How do you migrate data from one environment to another?

653


How many transformations can be used in mapplets.

1468


can we override a native sql query within informatica? How do we do it?

660


what are 3 tech challenges/ common issues you face?

1898


What is workflow? What are the components of workflow manager?

717


Can we create two repositories on same database instance in oracle?

621


What is main use of mapplet?

669


What is the Rank index port in Rank transformation?

678


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1629


How to extract sap data using informatica? What is abap? What are idocs?

570