Answer / swetha

If you configure a session in a sequential batch to stop on
failure, you can run recovery starting with the failed
session. The Informatica Server completes the session and
then runs the rest of the batch. Use the Perform Recovery
session property

To recover sessions in sequential batches configured to stop
on failure:

1.In the Server Manager, open the session property sheet.

2.On the Log Files tab, select Perform Recovery, and click OK.

3.Run the session.

4.After the batch completes, open the session property sheet.

5.Clear Perform Recovery, and click OK.

If you do not clear Perform Recovery, the next time you run
the session, the Informatica Server attempts to recover the
previous session.

If you do not configure a session in a sequential batch to
stop on failure, and the remaining sessions in the batch
complete, recover the failed session as a standalone session.

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

What do mean by local and global repository?

0 Answers  

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

What is the default source option for update stratgey transformation?

1 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---