Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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


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

Post New Answer

More Programming Languages AllOther Interview Questions

Define distributed queries. can you explain me as soon as possible

0 Answers   HCL,


When you deliver your C++ headers and C++ library of a class (what all can you change in the class so that application using your class does not need to recompile the code)

0 Answers   Yahoo,


Which CRM is better to opt, Sebiel CRM or Salesforce CRM or sap CRM? which institute is best one in hyderabad

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  


About CLR, reflection and assemblies?

2 Answers   pspl,


Which of the following are Java modifiers?

0 Answers  


1. How many jobs can we write in a single file? 2. How many maximum members can exist in a single partition data set(pds) in jcl?

0 Answers   Steria,


what are all the ant command options

0 Answers  


swap two number wthout using third variable

4 Answers   eClerx,


Difference between delegates and Events?

0 Answers  


i am getting the error while compiling my cics program with including db2 dclgen member it is showing that ur dclgen member not including and all the host variables are undeclared

0 Answers   TCS,


1.what is the vesition managment.

0 Answers   IBM,


Categories