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
- 2247 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
73. How can you set the status and title for a modal dialog box? a) In the attributes of the corresponding screen. b) Before the corresp. call screen statement. c) In a PBO module of the corresponding screen. d) In the PAI module of the corresponding screen.
whats the Need for Concurrency control
What are scrubbing procedures in SAS
explain how to make a control visible and invisible during runtime
What is the difference between save and create method of activerecord?
What does this useful command line do? tasklist /m "mscor*"
What is the difference between procedure -oriented language and object oriented language?
22 Answers IBM, Infosys, TCS,
if there are n nodes in a binary tree, how many null pointers are there?
how can i split string in a textbox in windows appication using C#.net
How can recruiter justified that the candidate is expert in Algorithm and datastructure for Software product development ?
How do i find out the number of parameters passed into function?
what is the diffrence between software and hardware language?
C 
