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

Can you use one mapping to populate two tables in different schemas

2 Answers  

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

Can a joiner be used in a mapplet.

1 Answers  

Can we create multiple integration service on single repository?

0 Answers  

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

expain about the tune parameters?

0 Answers   TCS,

What is dimensional table?

0 Answers