Answer Posted / 9885657928

1.Source
2.Exteact
3.Tranform
4.Load
5.Taget

Explain what are the steps to build the data warehouse?

885

---

Explain the differences between normalizer and normalizer transformation?

947

---

what are the others of "bad files" and "discard files" when using sql*loader?

2055

---

The same tier?

976

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

869

---

What is a view as it relates to system modeling?

929

---

Explain why denormalization is promoted in universe designing?

905

---

In document how to create metrics?

930

---

Explain difference between e-r modeling and dimentional modeling?

914

---

Explain what are the different types of join operations?

912

---

What is static and local variable?

975

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2206

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

966

---

Which columns go to the fact table and which columns go the dimension table?

918

---

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1921

---