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 session c#?

915

How does pig work?

557

Do you have to re-create mappings each time?

862

What is floating point number in swift? What are the different floating point numbers in swift?

763

What is sneakernet?

304

What are the problems with Hadoop 1.0?

992

How to read a pf in reverse(from last record to first) using cl?

1053

What is a directive order?

819

How to create an array from php string?

983

server.transfer limitation ?

2175

How would you categorize windows azure?

600

What is view factor ?

1250

When should you increase copy latches? What parameters control copy latches?

527

Write the chemical formula for epsom salts?

1032