can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

explain abt union t/r?

1 Answers   IBM,

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What is an aggregator transformation?

0 Answers  

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---