Answer / ranjeet

does this question have any sense, I don't think so

Answer / satyaranjan

Always load data from dimension to fact is incremental load

Answer / vikaskrmails@gmail.com

fist of all, Fact and Dimensions are separate entity tables
because fact contains measures and PK and FK where as Dim
contains Detail data along with PK and FK.
Dimensions and fact's loaded by their different sources
first we load dimensions and simultaneously assigned it to
surrogate key by sequence or CSUM etc functions. dimension
can maintain FK for other related dimensions and facts.
after loading fact we are updating it with Dim's PK-FK by
lookup.

Answer / elango

fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

Explain the use of aggregator cache file?

0 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---