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 is scd?

Answers were Sorted based on User's Feedback



what is scd?..

Answer / pradeep

scd-slowly changing dimension
It is the capturing the slowly changing data which changes
very slowly with respect to the time. for example: the
address of a custumer may change in rare case. the address
of a custumer never changes frequently.

there are 3 types of scd. type1 - here the most recent
changed data is stored
type2- here the recent data as well as all past data
(historical data) is stored
trpe3- here partially historical data and recent data are
stored. it mean it stores most recent update and most recent
history.
As datawarehouse is a historical data, so type2 is more
usefull for it.

(welcome new answers)

Is This Answer Correct ?    15 Yes 2 No

what is scd?..

Answer / sai suresh

SCD: Slowly changed dimention
The SCD how to Capture the change data with respect to the
time. For ex: In an organization emp sal is chaged
according to his perfomence after chaned sal we kept in
datawarehouse. (Datawarehouse maintain a Historical data )
there are 3 types of SCDs.
Type1: It will maintain curren data only. It does't
maintain historical data.
Type2: It maintain current and historical data.
Type3: It maintain current and previous data it mease
Parcial data only maintain.
So generelly datawarehouser is maintain Historical data
hence Type 2 is useful

Is This Answer Correct ?    15 Yes 2 No

what is scd?..

Answer / rr

Slowly changing Dimension

Is This Answer Correct ?    12 Yes 3 No

what is scd?..

Answer / vignesh muralidharan

The datas are kept in the data base
through the slowly changing dimension process.There are
three types in slowly changing dimensions:
type1,type2.type3.

Is This Answer Correct ?    12 Yes 7 No

what is scd?..

Answer / rekha

SCD IS SLOWLY CHANGING DIMENSION
SLOWLY CHANGING DIMENSIONS ARE DIMNESION TABLES WITH SLOWLY
INCREASING DATA AS WELL AS UPDATES TO THE EXISTING DATA
THERE ARE THREE TYPES OF DIMENSIONS
TYPE 1
TYP2 - VERION ,FLAG ,EFFECTIVE
TYPE3

Is This Answer Correct ?    5 Yes 0 No

what is scd?..

Answer / mikayla

scd is Sudden Compulsive Dpepression

Is This Answer Correct ?    1 Yes 18 No

Post New Answer

More Informatica Interview Questions

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,


How informatica recognizes mapping?

2 Answers   CTS,


source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


What is update strategy transform?

0 Answers  


connected and unconnected lookups?

4 Answers  


how did u understand business requirement?

2 Answers   TCS,


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  


Explain reference cursor?

1 Answers  


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


What is the sequence generator transformation in informatica?

0 Answers  


in static and dynamic which one is better

2 Answers  


Categories