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
- 2317 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to add Servlet-api.jar file into eclipse 3.3.2 ?
this question is from sas:what is the difference between FILE and INFILE statements? plz explain in brief?
what is different betweet class and interface in java?
2 Answers Microsoft, Sun Microsystems,
Hello...has anyone interviewed with Information Management Services(IMS)located in Silver Spring MD??If yes,what can you share about the programming test and the analytical test?
0 Answers Information Management Services,
When you?re running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?
what are the steps for creating prompt table dynamically for the specified field
what is difference between kpo and it industry? that is in terms of work, package etc
can any one suggestion me present which course(except java,.net) has huge demand in the market?
sample and simple coding where we get?
Write a program that prints the numbers from 1 to 100. But for multiples of three print "Fit" instead of the number and for the multiples of five print "Bit". For numbers which are multiples of both three and five print "FitBit".
you have an unlimited supply of $3 and $7 poker chips. What is the largest integer value that you cannot make by combining different numbers of chips?
is possible to delete specific data in a row by using of sql query?
C 
