Answer / nagaraju bhatraju

A standalone session is a session that is not nested in a
batch. If a standalone session fails, you can run recovery
using a menu command or pmcmd. These options are not
available for batched sessions.

To recover sessions using the menu:

1. In the Server Manager, highlight the session you want to
recover.

2. Select Server Requests-Stop from the menu.

3. With the failed session highlighted, select Server
Requests-Start Session in Recovery Mode from the menu.

To recover sessions using pmcmd:

1.From the command line, stop the session.

2. From the command line, start recovery.


U CAN DO IT BY PERFORMANCE RECOVERY
WHEN THE SERVER RUNS THE RECOVERY SESSION , SERVER READS
THE DATA FROM OPR_SRVR_RECOVERY TABLE AND NOTES THE ROW ID
OF THE LAST ROW COMMITTED TO THE TARGET TABLE ,THEN
INFORMATICASERVER READS THE ENTIRE SOURCE AGAIN AND PROCESS
THE DATA FROM NEXT ROW
BY DEFAULT PERFORMANCE RECOVERY IS DISABLE ,HENCE IT WONT
MAKE ANT ENTRIES IN TO OPR_SRVR_RECOVERY TABLE

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

What is parameter file?

2 Answers  

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---

how to duplicates from expression transformation without using sorter before that

1 Answers  

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

What is the session task and command task?

0 Answers  

---