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

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

What is difference between a gateway node and worker node?

0 Answers  

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

Why sorter is an active transformation?

0 Answers   Informatica,

What are the differences between a connected lookup and unconnected lookup?

0 Answers