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

tell me the push down optimization

2 Answers   Wipro,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

---

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

0 Answers   Informatica,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

wf dont have integration severances how you can run?

0 Answers   TCS,

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

What is an Integration service in Informatica?

0 Answers  

---