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 |
what are the settiings that u use to cofigure the joiner transformation?
what are the deliverables?in your project?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
Howmany ways yoU can update a relational source defintion and what are they?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the use of source qualifier?
What are the tasks that Loadmanger process will do?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What is data merging, data cleansing and sampling?
can we override a native sql query within informatica? How do we do it?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??