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 type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---

how to convert the .doc docs into .txt format using informatica

4 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

Can you use flat files in Mapplets.

0 Answers  

---

Parameter and variable differences

0 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

Explain the types of lookup transformation?

0 Answers  

---

Write the advantages of partitioning a session?

0 Answers  

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---