How to swap values between two variables without using a third variable?

24 Answers   HCL, TCS,

---

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  

---

kindly send interview materials

0 Answers   SoftSquare,

---

in IBM PC -AT.WAT AT REFERS TO?

0 Answers   IBM,

---

10.Define filters,binary to hexadecimal,hexadecimal to decimal?

0 Answers  

---

Diff between Proc transpose and Arrays with example?

2 Answers   Accenture,

---

what is the purpose of postback?

2 Answers   Nth Solution,

---

i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......

0 Answers  

---

Indentify the essential difference between GUI and a command line operating systems?

1 Answers   Deloitte, Infosys, Wipro,

---

Binary tree?

1 Answers   Mascot,

---

Explain with examples any 2 features of OOPS.

0 Answers   Tavant Technologies, Verifone,

---

Do not use more than 3 nested IF. Use Evaluate statement in case of more IF required. Please give a detail explantion besides readability and clarity for Evaluate stmt.

0 Answers  

---