Answer / swetha

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.

Answer / msb.dwh

SIMPLE BY USING MENU COMMAND PMCMD

what is mapping parameter?

2 Answers   Cap Gemini,

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

Define mapplet?

0 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

What are mapplets?

0 Answers  

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

can you use flat file for repository?why?

2 Answers   TCS,

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---