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 do you take back up of repository?
How do you load only null records into target?
What is different between the data warehouse and data mart?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
4 yrs etl devloper roles and responsibilities?any body give solutions
lookup transformation with screenshots
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Enlist the differences between database and data warehouse.
What are the types of data warehouses?
pmscmd startworkflow -sv
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to differentiate between the active and passive transformations?
explain one complex mapping with logic? sales project?
What are the components of workflow manager?