Answer Posted / senthil

hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..

star schema used in data warehousing ..

Explain the shared cache and re-cache?

1049

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200

---

Is there any way to read the ms excel datas directly into informatica?

978

---

What are the main features of Oracle 8i with context to datawarehouse?

2052

---

Tell me about Propagate functions in informatica

874

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1792

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2094

---

What is Cognos script editor?

4163

---

How to generate sequence numbers using expression transformation?

1026

---

What is dimensional table?

1002

---

How we can use union transformation?

989

---

What is the sql query overwrite in source qualifier in informatica

1026

---

What is sorter transformation?

976

---

tell me about your project functionality

2294

---

How can you validate all mappings in the repository simultaneously?

1287

---