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  

---

What is the difference between CLEAR & RESET and OPEN & CLOSE OPCOEDS(USING RPG/400).wheare we can use this?can any body tell me in real time senario with example please?

0 Answers  

---

What are scrubbing procedures in SAS

1 Answers   IBM,

---

give idea for creating screen in abap

0 Answers  

---

this question is from sas:what is the difference between FILE and INFILE statements? plz explain in brief?

1 Answers  

---

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

0 Answers   Zensar,

---

Please anyone tell me coding to print prime numbers from 1 to 5000 in c#....

2 Answers  

---

i am exeprienced person what is selection process

0 Answers   BitWise,

---

what is difference between c and C#

12 Answers   MCN Solutions,

---

how MATLSB software suitable for electrical branch? which tools are useful??

1 Answers  

---

Differevce between arrays and array builders?

0 Answers  

---

What is the Super Class of Exception in java?

11 Answers   Andesa Services, Benchmark, CitiGroup, CMC, Evergent, KOT Systems, Value Labs, Vijay infoart Solutions,

---