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...

What are slowly changing dimensions?

Answer Posted / sandeep.t nizamabad

DIMENSIONS ARE CLASSIFIED INTO THREE TYPES
SCD TYPE-1 (MAINTAIN CURRENT DATA)
SCD TYPE-2 (MAINTAIN CURRENT DATA+FULL HISTORY OF CHANGES)
SCD TYPE-3 (MAINTAIN CURRENT DATA+ONE TIME HISTORY)

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is it possible to index the data in cache of lkp transformation ?

2033


Write the advantages of partitioning a session?

1285


What is blocking transformation?

1152


what are the deliverables?in your project?

2152


While migrating the data from one environment to another environment how would you manage the connections?

1091


How to extract the informatica rejected data?

1225


What are the different components of powercenter?

1055


How union transformation is used?

1012


What is an active transformation?

1115


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1127


What is the advantage of informatica?

1069


What are the main features of Oracle 8i with context to datawarehouse?

2115


What is target designer and target load order?

1111


What are the types of lookup transformation?

1084


How can a transformation be made reusable?

1173