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 the need for an etl tool?
Differentiate between a database and data warehouse?
What is a node in Informatica?
How to update or delete the rows in a target, which do not have key fields?
What are Dimensional table?
Parameter and variable differences
Explain what are the different types of transformation available in informatica.
What is sequence generator transformation in informatica?
What are the features of complex mapping?
Explain the types of lookup transformation?
What is the need of etl tools?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain what is informatica metadata and where is it stored?
without table how to come first record only in oracle?
Which transformation should we use to normalise the COBOL and relational sources?