Question { TCS, 25177 }

Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?

Answer

(1)The FWM uses cognos SQL as a default SQL to create and
edit query subjects.
(2)cognos sql supports SQL 99 standards, which are used in
modifying the query subjects.

Where as

(1) The native SQL is the SQL the database uses such as
oracle,sql secver etc.
(2) A cognos query definition engine (QDE) convert the
cognos SQL into a native SOL which will be submitted to the
data source to query the data.

Question { Polaris, 19862 }

What is the difference between filter & Condition?

Answer

-> A filter is a restriction that reduces the amount of data
returned from data base.
-> A condition is created with the three components
1.Query item
2.Operator
3.Operand
=> In addition, The model filters are reusable which can be used for a multiple reports.

Question { IBM, 9633 }

what are determinants?

Answer

=> Determinants reflect granularity by representing subsets or groups of data in a query subject and used to ensure correct aggregation of this repeated data.

=> Determinants are most closely related to the concept of keys and indexes in the data source and are imported based on unique key and index information in the data source.

=> By modifying Determinants, you can override the index and key information in your data source,replacing it with information that is better aligned with your reporting and analysis needs.

Question { IBM, 9018 }

when can i use the STAR Schema and SNOWFLAKE Scgena

Answer

=>
-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.