how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

Explain the etl program with few examples.

0 Answers  

---

what are surrogate keys?

5 Answers  

---

What is the benefit of session partitioning?

0 Answers  

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---