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
- 1627 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Urgent Openings for Java and .NET ( India, Singapore, Australia, Japan)
While joining files if only two files are mentioned with jfile keyword, do we required to use join keyword????
Is there any standard procedure to test the application as a whole? Or How can I test complete application right from the requirement gathering?
How to set on/off a group of indicators in a single statement?
Explain what is OOPS and its concepts?
what is d main diff between the java and .net framework
Write a Pseudo Code to find the angle between two hands of a clock for a given time.
what is session state?
Difference between delegates and Events?
how will you do destructive read and non destructive read in data queue.....
how to run servlets in eclipse 3.3.2....if we choose file->new->servlet then after that it is showing javax.servlet.* ...cannot be resolved.......to avoid this error any external jar file is to be added? please help me regarding this issue........thank u
Java is called as pure objerct oriented programming language, where as c++ is not completely object oriented.can any explain the detailed differenec between these two
C 
