Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

What are the types of caches in lookup?

0 Answers  

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

What is the Hierarchy of DWH?

1 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

What is expression transformation?

0 Answers  

---

Why we need XMLs?

3 Answers   IBM,

---