if the session fails after 100 records agian we have to
starts the
session or we go for recovery session
Answer Posted / guest
informatcia server has 3 methods to recovering the
sessions.
1)Run the session again if the Informatica Server has not
issued a commit.
2)Truncate the target tables and run the session again if
the session is not recoverable.
3)Consider performing recovery if the Informatica Server
has issued at least one commit.
Use performing recovery to load the records from where the
session fails.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the advantage of informatica?
What the difference is between a database, a data warehouse and a data mart?
What is enterprise data warehousing?
What are the types of caches in lookup? Explain them.
Explain what are the different versions of informatica?
How to partition the Session?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is option by which we can run all the sessions in a batch simultaneously?
What is an expression transformation in informatica?
What you know about transaction control transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Where are the source flat files kept before running the session?