Answer / subbu

for huge amount of data snowflake schema is the best.and
for less amount of star schema is better

Answer / saptashaw

Star is better for performance.
Snowflake happens when one or more dimension tables in the
Star are normalized. This is done when there is sparsity in
the concerned dimensions.

Answer / satya/gunu(satyabadi)

=>
-Star schema is highly denormalized.
-Snowflake schema is normalized.
=>
-As star schema is denormalized, the size of DWH will be larger than that of Snowflake schema.
=>
-Performance wise, star schema is good.
-But if memory utilization is a major concern,then snow flake schema is better than star schema.
=>.. In addition, Generally in real time, we use Snowflake schema only.

Answer / khushbu

snowflake is normalized model there for it require less storage space.
but star schema is not normalized. it has redundant data therefore require more storage.

fiscal year means what???

8 Answers   iFlex, iGate,

---

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 Answers  

---

What are the components of report net?

0 Answers  

---

How to select multiple values from type-in prompt?

0 Answers  

---

What are types of batch available in cognos?

0 Answers  

---

How to do deployment?

5 Answers  

---

What is the metric store database?

0 Answers  

---

what is the use of layout component reference

3 Answers   Satyam,

---

What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  

---

-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,

---

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,

---

difference between stored procedure and function?

4 Answers   Syntel,

---