Answer Posted / chowdary

There are two types of shemas
1 star schema , 2 snowflake schema
star schema : a fact table related to tha dimension tables
like in the fact table it contain refernce keys of
dimension tables. and dimension tables dont related to the
other parent table . it view like a star so its call star
schema. if this use to avoid more joins
snowflake schema: a dimenion table with related to the it
hirerchi tables. like time dimensin table year dimension
table, month month dimension table, week dimension table
it view like snowflake

What are the databases that informatica can connect to windows?

1000

---

tell me the rules and responsblites in our project(my project is development)

1874

---

explain one complex mapping with logic? sales project?

6591

---

What is Index Caches size?

1053

---

Explain how many types of dimensions are available in informatica?

1005

---

What is flashback table ? Advance thanks

1871

---

What is the difference between Active and Passive transformation?

1079

---

How big was your fact table

1743

---

Explain about cumulative Sum or moving sum?

975

---

What is main use of mapplet?

1068

---

What is meant by lookup transformation? Explain the types of lookup transformation?

895

---

what is SDLC way of code development?

1966

---

update strategy transformation in informatica

1013

---

How can we update a record in the target table without using update strategy?

1086

---

without table how to come first record only in oracle?

2203

---