Any one tell me some 5 session failure in real time?And why
problem occur how to solve the issues?
Answer / 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 |
What happens when a session fails and you click on recover?
Explain about the concept of mapping parameters and variables ?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
How to update records in Target, without using Update Strategy?
How to use pmcmd utility command?
What is Datadriven?
How to handle decimal places while importing a flatfile into informatica?
disable caching in a lookup transformation?
In real time scenario where can we use mapping parameters and variables?
What is synonym?
what is junk dimension