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

2343

---

Briefly define and explain the following different types of Pulse Amplitude Modulation (PAM) with some examples. i) 2-PAM ii) 4-PAM iii) 8-PAM iv) 16-PAM v) Quadrature Amplitude Modulation (QAM)

2143

---

Name the different type of tableau?

424

---

Does QTP record on Objects created on XWindows Environment?

2202

---

What is time sleep in python?

928

---

Does objective c have function overloading?

1

---

HOW MUCH LATEST ACCOUNTING STANDARDS , TDS RATE , INCOME TAX RATE, EXCISE , VAT , SERVICE TAX & FBT RATES? (PLS. ARRANGE TO SEND THE RATES FOR ABOVE IN CATAGORY & LIMIT WISE)

3481

---

What are the advantages of nichols chart?

1312

---

How do you get a list of all the keys in a dictionary in python?

935

---

What is jdbc odbc driver?

1035

---

What is the benefit of an android library project?

923

---

Is drupal scalable?

116

---

Is laravel built on symfony?

681

---

Is predicate a functional interface?

973

---

What is static analyzer?

1109

---