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
What is target load order?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Global and Local shortcuts. Advantages.
How many types of sessions are there in informatica.please explain them?
which one is better performance wise joiner or look up
What are the different clients of powercenter?
What is a code page?
Make a note of the quantity vaults made in informatica?
What is the difference between router and filter?
What is status code in informatica?
What is an active transformation?
How to configure mapping in informatica?
What is a snowflake schema?
What is lookup change?
how to load dimension table and fact table. plz tell me the steps.