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
- 2423 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Data Structure: How many comparisons are necessary to find the largest and smallest of a set of n distinct elements?
To sorting array of 10 elements which sorting is best a)selection b)bubble c)tree sort
A, B and C are 8 bit nos. They are as follows: A 1 1 0 1 1 0 1 1 B 0 1 1 1 1 0 1 0 C 0 1 1 0 1 1 0 1 Find ( (A-B) u C )=? how to solve this need with steps
2.Different data types in C? and its value and range?
What is the best action a system can take when deadlock is detected
code for connection from windows forms to sql server
What is std::auto_ptr?
Write 5 differences between Memory Reference Instruction and Register Reference Instruction.
what you mean by mantis in IT interview? why we use mantis? advantage of mantis?
how to study PHP my own? i reffered many sites.. but as being a fresher i couldnt follow those... which site will be the best one?
What is meaning of web application. & the purpose of web application. with description.
Hai, My name is nisha.I have NIC exam.If anybody Knows NIC previous paper pattern pls send me to nishanairp@gmail.com
C 
