1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / raghu

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
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

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

Answer / rekha

U CAN GO FOR PERFORMACE RECOVERT ,IF THE SERVER PERFORMS
ATLEAST ONE COMMIT

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

what is the architecture of any Data warehousing project?

5 Answers   IBM,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

What are the types of caches in lookup? Explain them.

0 Answers  

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

What are the advantages of informatica?

0 Answers  




When will you use SQL override in a lookup transformation?

1 Answers  

what is difference between COM & DCOM?

1 Answers   Satyam,

What is A complex mapping?

3 Answers   TCS,

What is degenerated dimention table?

7 Answers   Patni,

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

Differnce between filter and router?

14 Answers   IBM,

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories