Answer / mayur

hi,

see i would like to answer it through on example:

consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..

now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...

& even a complex sql is effectively implemented...


finally this will enhance ur performance & a effective development logics ....

Answer / sampath kumar

Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---

what is universe testing(not mention check integrity)

1 Answers  

---

Explain what three things do you consider to be the most important factors for a manager?

1 Answers  

---

What would you consider as your biggest achievement and why?

1 Answers  

---

What are the join problems comes appart from loop,chasm & fan Traps

1 Answers   IBM,

---

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers  

---

What is thumbnail?

1 Answers  

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,

---

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  

---

How many universes can be created in a project?

1 Answers  

---