Answer Posted / t chinna shareef

SQL>set serveroutput on;
SQL>begin
2 dbms_output.put_line("ARCHANA");
3 end;
4 /

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

1647

---

V2 SOLUTIONS APTI paper is very easy there are 3 sections 1'st is quant problem on age train traveling speed is given length of train is given we have to find out length of bridge then prob on calender one date is given on Friday hv to find out day of othe date ans is Friday then there was 1 prob on percentage which was very easy ans was 21340 then 2’nd section was english grammer had has been being like that hv to fill in the blanks was very wasy then last section was find relative words there was five Q 1 pant ANS:-breath 2inquire ans :- ask And 3 more out of that 1 ‘s ans was:- body 4 And others ans was :-through THEN THEY HAVE GD There was three topics 1 should we allow india’s talent to go to abrod 2 protest against seperate state is justify 3 inturuption of politics in cricket Thats all guys i cleared both the rounds now preparing 4 interview best of luck

1779

---

difference between mantis and other tools?

1620

---

How to change the color of a cell or a row in a datagrid on mouse hover using javascript/.net

1537

---

It is possible to take number of controls added to form at run-time.ex-when user enter 6, 6 text boxes get added to form,next time number of controls get change as per user number enter. What is code for that?

1511

---

---

what are importance in problem tracking

1623

---

what is d main diff between the java and .net framework

1548

---

pleasew define carrier scope in abap (sap).

2108

---

what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct

1686

---

what is dot net framework

2346

---

I am looking for NIC Sample papers or any patern of questions/ syllabus plz, send me on hamid.khan135@yahoo.in Regard

1543

---

what is the meaning of without standing arrears?

9864

---

iam confused among testing ,.net and java. can anybody help me.

1578

---

what is delegate and how works delegate and event.

1769

---

how to add Servlet-api.jar file into eclipse 3.3.2 ?

4061

---