Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2228 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
give idea for creating screen in abap
1. How many jobs can we write in a single file? 2. How many maximum members can exist in a single partition data set(pds) in jcl?
WAP to print all prime nos between 1 to 100 without using user input...pls reply within few hours...
When you?re running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?
I want to pass .pdf files as OlE Object to crystal report through VB6. Please any one guid me...
this question is from sas:what is the difference between FILE and INFILE statements? plz explain in brief?
How to change the color of a cell or a row in a datagrid on mouse hover using javascript/.net
what is the basic and unique feature of dotnet
what is the difference between a namespace and assembly ?
how many languages .net is supporting now?
Iam using Microsoft Visual Studio to create a system for mobile store I want to know how to calculate mobile price that the customer buy and how to reduce quantity from the data base that we have for mobile .And also how to calculate revnue for each mobile and revnue for the total mobile
How to rename A1-A30 datasets into B1-B30 using macros?
C 
