Answer Posted / parvar

1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house

How to handle multi value dimensions?

2241

---

Explain why fact table is in normal form?

944

---

Is there any difference in testing database and data ware housing?

2716

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1036

---

What are aggregate tables and aggregate fact tables?

978

---

Explain normalization?

1069

---

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1999

---

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1003

---

What is the advantages data mining over traditional approaches?

928

---

how much memory space occupied real time project (roughly)?

2191

---

Can decision tree be implemented using SQL?

2082

---

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

970

---

Define Data Warehousing?

1119

---

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2201

---

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

2224

---