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 |
select count(1) from emp? what is the o/p?
how i will stop my workflow after 10 errors
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
connected and unconnected lookups?
If I have a index defined on target table and if set it to bulk load will it work ?
How mapping parameter and variable works
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
How informatica recognizes mapping?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
Can I create one wrkflw which will run different wrkflws on schedule time?
Where is the cache stored in informatica?