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
- 2429 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
sample code for data transfer between two r/2 systems and r/3 systems?
how much fee for deccan soft institute .how to block seat for sandeep sir class reply soonnnn
Need guidewire related Documents(Interview Question/Tips/Best Practice/Dumps)
WHAT IS MAIN IMPORTANT THING IN SOFTWARE?
difference between mantis and other tools?
what is woransient key word? how it is used in java
Why multiple inheritance is removed in java?
how to add Servlet-api.jar file into eclipse 3.3.2 ?
How to get the index of the clicked field in reports in ABAP?
why rownum=1 works properly but not rownum=>2,=>3 etc.
What is ur porject Architecture? If anyone ask what i have to specify here..
What is the best action a system can take when deadlock is detected
C 
