Answer Posted / vidyanand

Mostly preferable is Star schema where query performance
will be high comparing to snowflake Schema.

Snowflake schema is used only where performance issue will
not come into matter.

So, better to use star schema rather than snowflake schema.

what are factless facts? And in which scenario will you use such kinds of fact tables.

1744

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1933

---

What is the sql query overwrite in source qualifier in informatica

1029

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1081

---

Sequence generator, when you move from develoment to production how will you reset

1943

---

What happens when a session fails and you click on recover?

1065

---

How to do the error handling of if ur source is flatfiles?

1913

---

Write the program through which the records can be updated?

938

---

update strategy transformation in informatica

1017

---

What do you understand by term role-playing dimension?

982

---

What is persistent lookup cache?

970

---

Can you generate sequence numbers without using the sequence generator transformation?

1054

---

How do you load only null records into target?

1145

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1272

---

What is a node in Informatica?

1004

---