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
How many dimensions are there in informatica?
How does a sorter cache works?
What do you understand by term role-playing dimension?
What do you mean by channel change?
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.
How do you migrate data from one environment to another?
How many transformations can be used in mapplets.
can we override a native sql query within informatica? How do we do it?
what are 3 tech challenges/ common issues you face?
What is workflow? What are the components of workflow manager?
Can we create two repositories on same database instance in oracle?
What is main use of mapplet?
What is the Rank index port in Rank transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to extract sap data using informatica? What is abap? What are idocs?