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


Please Help Members By Posting Answers For Below Questions

How do you take back up of repository?

945


How do you load only null records into target?

990


What is different between the data warehouse and data mart?

855


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 ?

1438


4 yrs etl devloper roles and responsibilities?any body give solutions

1880


lookup transformation with screenshots

3789


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5747


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?

853


Enlist the differences between database and data warehouse.

835


What are the types of data warehouses?

1204


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1312


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8040


How to differentiate between the active and passive transformations?

868


explain one complex mapping with logic? sales project?

6430


What are the components of workflow manager?

829