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
In how many ways we can create ports?
Does an informatica transformation support only aggregate expressions?
How we can create indexes after completing the load process?
Can you generate sequence numbers without using the sequence generator transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How big was your fact table
Different sorts of metadata that stores in the storage facility?
Explain load alternative records / rows into multiple targets - informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is meant by incremental aggregation?
Define the various join types of joiner transformation?
Explain sql transformation in script mode examples in informatica
What is resilience time?