Answer Posted / chaitanya

SCD, is a technique used to store the historical value of
dimension attributes.

The values of dimensional attributes change as time goes by.
When these attribute values change, you can overwrite the
old values with the new ones, or you can
preserve the old value.

There are two methods of preserving the old attribute
values: you can store the old values as rows, or you can
store them as columns

three types of SCD:
• SCD type 1 overwrites the old values of the attributes so
the old values are not kept.
Ex: In product dimension,we will use SCD type 1, meaning we
will overwrite the old attribute values.

SCD type 2 keeps the old values by creating a new row for
each change.
SCD type 3 keeps the old values by putting them in another
column

Why filter transformation is an active one?

992

---

What is meant by LDAP users?

1218

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7410

---

Enterprise data warehouse your projects phase by phase explain?

1931

---

What are the different types of repositories created using informatica?

1146

---

What is different between the data warehouse and data mart?

1078

---

Partition, what happens if the specified key range is shorter and longer

2505

---

Explain lookup transformation in informatica

1081

---

What are Dimensional table?

1068

---

What are the restrictions of union transformation?

1045

---

What is sq transformation?

1173

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10692

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3708

---

Performance tuning( what you did in performance tuning)

1998

---

tell me 5 session failure in real time how can you solve that in your project?

2309

---