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,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

what is incremental aggregation ,with example?

2 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

---

What is the different lookup cache(s)?

0 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

What is decode in static cache?

0 Answers  

---

What is a joiner transformation?

0 Answers  

---

Whats the difference between $, $$, $$$

9 Answers  

---

In joiner, how to load Master table in Target?

2 Answers  

---

what is runtime variable?

3 Answers   TCS,

---