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 are connected or unconnected transformations?

0 Answers   Informatica,

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

What is factless fact schema?

1 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---