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

What is the need for an etl tool?

844


Differentiate between a database and data warehouse?

903


What is a node in Informatica?

824


How to update or delete the rows in a target, which do not have key fields?

907


What are Dimensional table?

806


Parameter and variable differences

1845


Explain what are the different types of transformation available in informatica.

788


What is sequence generator transformation in informatica?

836


What are the features of complex mapping?

874


Explain the types of lookup transformation?

788


What is the need of etl tools?

842


What is a shortcut and copy in Informatica and how two are different with each other?

939


Explain what is informatica metadata and where is it stored?

827


without table how to come first record only in oracle?

2050


Which transformation should we use to normalise the COBOL and relational sources?

968