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
- 2340 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Suppose i have all the implementation code required is written in doGet() but my class has doPost() method. i need code implemented in doGet() how can we do that?
Hello Experts, What is the difference between move and move corresponding exactly? please post me asap
In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..
write a program for finding the union of two integer array in java?
What ports must be open for DCOM over a firewall? What is the purpose of Port 135?
the systematic access of small computers in a distributed data processing system is referred as?
how many logical drive we can form to physical device in our computer?
Explain polymorphism. Provide an example.
what are the things i had to say in personal introduction in hr round mail me to prasanna.1867@rediff.com
you have a computer with 80GB hard disk and ubuntu 8.04 is installed on entire hard disk.now you have to create a seprate partition for windows OS and install win XP as dual boot.write down the steps involved along with the commands
1 Answers Anand Group, Indian Navy, TCS,
what are partial classes. Where is the entry point of partial classes.
Find out the list of roles which gives access to GUI activities? thanks in advance
C 
