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

2235

What is arraylist e?

1023

how to implement a web service in .net

924

How do you wrap text in word 2010?

554

Does oxygen and hydrogen map up water?

1921

What are badges in bootstrap?

1

What happens in a conflict? How do you handle that?

992

What exactly do you know about the sap fico?

970

Explain vendor return procedure and its mapping in sap?

1174

explain different types of backups avaialabe in sql server? : Sql server database administration

924

Is .net framework 4.8 the last version?

985

Does formatting a drive delete everything?

884

what is RNG in the DG synchronizing by PLC?

2073

How many arguments can be passed to main ()?

942

What are plankton, nekton, and benthos?

269