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 the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

What are roles and groups and benefits of using them?

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

Can a joiner be used in a mapplet.

1 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---