Answer Posted / ande

two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande

Differentiate between a database and data warehouse?

1193

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2057

---

What are Dimensional table?

1120

---

What is domain in terms of informatica?

1056

---

How to load the data from people soft hrm to people soft erm using informatica?

1067

---

is it possible to index the data in cache of lkp transformation ?

2076

---

How to use procedural logic inside infromatica?

1320

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1204

---

can we override a native sql query within informatica? Where do we do it?

1166

---

What is workflow? What are the components of workflow manager?

1232

---

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

1128

---

What is the use of source qualifier?

1184

---

How you prepared reports for OLAP?

1658

---

expain about the tune parameters?

2457

---

what is index?how it can work in informatica

2083

---