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  

---

Hi can you please help for the following. I have a ASP.Net web page I want to print the whole page how is it possible? I want It in ASP also.Please send me the solutions dipankar.hazari@gmail.com . Thanks in advance.

0 Answers   Philips,

---

What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe

0 Answers  

---

How can we alter the data after creating a view

1 Answers  

---

what is encapulation?

4 Answers   Syntel,

---

which worker is involved in all the phases of SDLC?

1 Answers  

---

What is the merger sort principle and its time complexity.

0 Answers   Verifone,

---

I am looking for selenium RC online Training in chennai. can any one tell me the best institute

0 Answers  

---

What is the entry point function of a DLL?

0 Answers   Wipro,

---

How to connect the .accdb database file of microsoft access to the Visual Basic 6.0 forms?

0 Answers  

---

MOV.CB 007H,ADCON1 MOVE.CT 001H,_OPTION_REG_7 MOV.CB 007H,CMCON

0 Answers  

---

what are the topics choosen for jam round for interviews

0 Answers  

---