hi all, i need ur help in preparing a sql which performs scd2, i mean i have a scd2 mapping i need a sql which can give me same result as scd2 mapping, SRC table: cust_no, loc 01 abc 02 xyz TGT table: pm_ky cust_no loc current_flag 1 01 abc Y 2 02 xyz Y cust 1 has changed his loc to xyz then it loads into TGT table as below, pm_ky cust_no loc current_flag 1 01 abc N 2 02 xyz Y 3 01 xyz Y i need sql to get the above result, hope got me question, Any suggestion will be appreciate.. thanks, Vinod

0 Answers  

---

Write a program to swap the content of two variables without using a third variable.

0 Answers   Zensar,

---

How do you initialize a static member of a class with return value of some function?

0 Answers   Yahoo,

---

1. How many jobs can we write in a single file? 2. How many maximum members can exist in a single partition data set(pds) in jcl?

0 Answers   Steria,

---

how to study PHP my own? i reffered many sites.. but as being a fresher i couldnt follow those... which site will be the best one?

0 Answers  

---

I need to fetch all rows from the table based one field value in the table and later do a condition check if the condition is true I will have to move all the rows present in the data base to output file one else if the condition is not satisfied then move all the records of that field value into another file .Please let me know how to do that

0 Answers  

---

what is runtime exception and compiletime exception ?

1 Answers   Accenture,

---

it is a language or tools?

0 Answers  

---

what is the meaning of without standing arrears?

0 Answers   TCS,

---

How to find the aerry size

1 Answers   Cap Gemini,

---

can we allocate memory for interface? if no then why?

0 Answers  

---

What is Partial class and its use?

1 Answers  

---