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

Explain lookup transformation source types in informatica

709


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

639


What is source qualifier transformation in informatica?

586


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

638


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

747






What you know about transaction control transformation?

566


Explain the different lookup methods used in informatica?

599


r u done any partitions in ur project?

1414


What's the layout of parameter file (what does a parameter file contain?)?

1929


Can we create two repositories on same database instance in oracle?

622


Explain your project of banking domian.

1223


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

636


Different sorts of metadata that stores in the storage facility?

574


What is the cumulative sum and moving sum?

770


What are the different versions of informatica?

694