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


Please Help Members By Posting Answers For Below Questions

In how many ways we can create ports?

694


Does an informatica transformation support only aggregate expressions?

602


How we can create indexes after completing the load process?

604


Can you generate sequence numbers without using the sequence generator transformation?

591


Under what conditions selecting sorted input in aggregator will still not boost session performance?

622






TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1459


How big was your fact table

1303


Different sorts of metadata that stores in the storage facility?

546


Explain load alternative records / rows into multiple targets - informatica

671


What are the basic requirements to join two sources in a source qualifier transformation using default join?

604


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?

624


What is meant by incremental aggregation?

571


Define the various join types of joiner transformation?

552


Explain sql transformation in script mode examples in informatica

590


What is resilience time?

647