if the session fails after 100 records agian we have to
starts the
session or we go for recovery session

Answers were Sorted based on User's Feedback

if the session fails after 100 records agian we have to starts the session or we go for recovery ..

Answer / guest

informatcia server has 3 methods to recovering the
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 ?    9 Yes 0 No

if the session fails after 100 records agian we have to starts the session or we go for recovery ..

Answer / rekha


Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   Infotech, IBM,

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

What are roles and groups and benefits of using them?

0 Answers  

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

what is the function of 'F10' informatica ?

4 Answers   IBM,

What is workflow monitor?

0 Answers  

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


1 Answers   TCS, Patni,

Two Default User groups created in the repository are ____ and ______

2 Answers