Answer Posted / krishna

in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.

How many input parameters can exist in an unconnected lookup?

1494

---

What are the tuning techniques you applied during your last project

1969

---

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

2188

---

Which is the t/r that builts only single cache memory?

1130

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2317

---

Can u generate reports in Informatica?

1027

---

can u any challenge your project?

1974

---

What is informatica powercenter repository?

1144

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2297

---

What is the Process to creating lookup transformation in informatica

984

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

951

---

What are the different options available for update strategy?

940

---

Differences between version 7.x and 8.x.

1843

---

How can we delete duplicate rows from flat files?

1165

---

What is a node in Informatica?

1005

---