Answer Posted / ravi sadanand

Star Schema: It is fully denormalized schema.the diagram of
fact table with dimension tables resembles a star that's
why it is called star schema.All the dimensions will be in
2nd normal form.
Snow flow schema:In this all dimensions will be in
normalized form.that's why it is called normalized star
schema.For each attribut a seperate table will be
created.As there is a possibility for more number of
joins,obviously the performance will be degraded.

Is it possible to use a client with different version than that of its Informatica server?

1189

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1126

---

What are the uses of etl tools?

1175

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1198

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2070

---

How to load data in informatica ?

1068

---

How do you load only null records into target?

1251

---

What do you understand by a term domain?

1173

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1097

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2300

---

What are the designer tools for creating transformations?

1158

---

What are the different transaction levels available in transaction control transformation?

1272

---

Reusable transformation and shortcut differences

1880

---

can anyone suggest best free Talend data integration training online

1742

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1164

---