Question { 4533 }

What are the uses of query explorer? Give example for each
use in detail. It is not given clearly in user guide so
explain in detail.

Answer

ACTUALLY THERE ARE 3 EXPLORERS
1)PAGE EXPLORER
2)QUERY EXPLORER
3)CONDITIONAL EXPLORER


IN QUERY EXPLORER WE CAN PERFORM UNION,INTERSECTION,MINUS
(EXCEPT) ETC OPERATIONS ON QUERIES AND REPORTS.

SHARATH

Question { IBM, 9809 }

How can we find out cardinality between two tables?

Answer

IN FRAMEWORKMANAGER GO TO WE HAVE 3 TABS

1)EXPLORER TAB
2)DIAGRAM MAP TAB
3)DIMENSION TAB

WE CAN CHECK CARDINALITY BETWEEN TWO TABLES IN DIAGRAM TAB.

SHARATH

Question { IBM, 13636 }

difference between join and union in reportstudio?

Answer

IN REPORT STUDIO JOIN IS USED TO JOIN TWO TABLES AND

UNION IS USED TO JOIN 2 REPORTS OR QUERIES.



SHARATH

Question { IBM, 8315 }

---------------What is meant by Scheduling?

Answer

SCHEDULING MEANS EXECUTING THE REPORT WHEN EVER DESIRED
AUTOMATICALLY WITH OUT ANY MANUAL INTERACTION.

SCHEDULING IS DONE AT COGNOS CONNECTION.

SCHEDULING CAN BE DONE BY HOUR
BY DAY
BY WEEK
BY MONTH
BY QUATER
BY YEAR
BY TRIGGER.

Question { IBM, 15571 }

-----------Diff b/W Aggregate Function and Rollup Aggrigate
Function?

Answer

AGGREGATE FUNCTIONS ARE USED AT DETAIL LEVEL(ROW LEVEL)

AND ROLLUP AGGREGATE IS USED AT SUMMARY LEVEL(GROUP LEVEL).



SHARATH

Question { CTS, 19972 }

-----------Types of Fact Tables?

Answer

THERE ARE 3 TYPES OF FACTS
1)ADDTIVE:FACTS THAT CAN BE SUMMED

2)SEMI ADDITIVE:FACTS THAT CAN BE SUMMED UP FOR SOME OF THE
DIMENSIONS AND NOT OTHERS.
EX:BANK BALANCE
3)NON ADDITIVE:CAN'T BE SUMMED.
EX:RATIO,AVG,VARIANCE

Question { 8431 }

What is Normalization?

Answer

NORMALIZATION MEANS TAKING A RAW DATABASE AND BREAKING IT
INTO LOGICAL UNITS CALLED TABLES IS CALLED NORMALIZATION.


DENORMALIZATION MEANS TAKING A NORMALIZED DATABASE AND
MODIFYING IT TO ALLOW CONTROLLED REDUNDANCY
FOR INCREASING DATABASE PERFORMANCE IS CALLED
DENORMALIZATION.