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)

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

Answer / rr

Slowly changing Dimension

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.

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

Answer / mikayla

scd is Sudden Compulsive Dpepression

Have you worked with/created Parameter file

0 Answers  

What is intricate mapping?

0 Answers  

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

What are Target Options on the Servers?

1 Answers  

Enlist some properties of sessions.

0 Answers  

can we use self join in informaitca?

3 Answers   IBM,

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

Which will beter perform IIf or decode?

3 Answers   TCS,

What are the different components of powercenter?

0 Answers