if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

in static and dynamic which one is better

2 Answers  

---

Define mapplet?

0 Answers  

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

what are the perameter and variable?

3 Answers   IBM,

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---