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

2261

Assume a thread has lock on it, calling sleep() method on that thread will release the lock?

1059

What is a parabolic signal?

1113

What does n a mean in vlookup?

617

Which method must be implemented by all threads?

1224

What is sql and its types?

1132

What is the difference between trace and debug in asp.net?

1101

How to Set a defaultrouter?

1584

State two to three differences between two stroke and four stroke engine?

1004

Is oracle java 11 free?

912

How to pass VAT retention entry on computer and Furniture

2879

Explain how do you find your body volume using a tape measure?

953

Give me examples of unstructured data?

455

Explain quality control?

1003

Can I transfer my outlook email to gmail?

3