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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Programming Languages AllOther Interview Questions

Data structure used to impliment a menu:

0 Answers   Verifone,


can we convert .class file to dll file

1 Answers  


What do you understand by modular programming?

0 Answers   Tech Mahindra,


I m Abdullah Ansari compleated MCA from Jamia Hamdard,i have appeared the test of IBM on 2 august at oxford college of engineering Bangalore.waiting for hr round.. This is the first round for IBM.02/08/08 Paper consists of 4 sections 15 questions from matrices(time very less but no negative marking). 25 questions from series completion section (this section is very easy but negative marking) 15 questions from aptitude(little bit tough time limit 15 minute negative marking) 4th section is from computer science (c,c++,operating system,digital electronics ,basic question..) result came at 3 o'clock.i was selected... In interview they asked questions like 1 they asked about final yr project.. 2 what are dynamic and static memory location? 3 linked list and array difference between them. 4 what is function ? what is difference betwen function and inline function? 5 about structure 6 about binary tree, traversal, call by value. 7 storage class and many more basic questions..

0 Answers   IBM,


.net 2005 supports how many languages?

4 Answers  


What is the output of the following x = "abcdef" i = "a" for i in x: print(i), a) no output b) i i i i i i … c) a a a a a a … d) a b c d e f

0 Answers   Peerless,


What is the Difference between in memory database and physical database

0 Answers  


details description on this mantis? who is founder of this mantis?

0 Answers  


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  


Difference between views and index in sas programming

0 Answers   Ventois,


in teradata level primary in table level allows duplicates why?

0 Answers   TCS,


in network security,how we identified threat?some one say we found threat according to it's signature,but how we get signature or pattern of the virus?

0 Answers  


Categories