What is design pattern ?4 7023
What is difference between GoF and J2EE patterns?1 8441
What is Architecture and what is design? Are they related?3 8122
how to entry of hra
What is iterable python?
Explain message service?
What is the purpose of clrscr () printf () and getch ()?
What is a user friendly software?
What is external css?
What is the difference between sonication and homozinization?
redundant connection in contactor?
How do I get flex to query my database?
What is new with android pie?
Short Answer on ___________Appreciation
What is ms-dos & why it is used for?
How do peptides react with cyanogen bromide?
How to Calculate The Neutral Earth flat design calculation for the Synchronised generator (Gen 1-650Kva, Gen 2-725Kva
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