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

what you mean by mantis in IT interview? why we use mantis? advantage of mantis?

1 Answers  


how pseudo column works?

0 Answers   Oracle,


How to use string functions in QTP?give some examples

1 Answers  


write a program on c(or)c++(or)java language i.e if i have 5 numbers like (10,24,3,9,15) i want to display highest number from these numbers

2 Answers  


class A{ void me(){s.o.p("");} class B extends A{ void me() {s.o.p(" ");} class M{ A a=new B(); B b=new A(); a.me(); b.mne();} what is the output of this, how?

2 Answers   Cosmos, HyTech Pro, WinSoft,






can any one suggestion me present which course(except java,.net) has huge demand in the market?

0 Answers  


Is the IT field raise again? What is the position of IT after 4 years?

0 Answers  


I've an application where i need to give access to all the features only to admin and only few features to normal users. Say Menu...i dont want all my menu items to be accessible to all the users only the admin people can see few all the features where as normal users can have access to limited menu items...how can i achieve this. Please note that my menu is not a database driven menu.

1 Answers   Tesco,


Hai, My name is nisha.I have NIC exam.If anybody Knows NIC previous paper pattern pls send me to nishanairp@gmail.com

0 Answers  


what is delimiter in sas ?

0 Answers  


Number of null pointers in any binary tree

5 Answers   Infosys,


What is meant by SQL,PL/SQL,SQL PLUS? Is there any differnece between them?

2 Answers   HSBC,


Categories