Tag: technology

Created along with other dimension

Does not have a primary key

Used to join two Schemas

Used to Join two Fact Table

Dimensions and Facts should be normalized and should be in snow flake form

Should have fact and dimension joined together in 3rd normal form

Contains additional information about dimensions in normalized form

None of the above

We cannot specify cardinality

We join all the tables to parameter variable

We should check for loops and fan traps

We cannot create a join between two dimension tables

Data about the fact

Data about other dimension

Data which is subject oriented and non volatile

Facts which could be normalized in a table

Used for group by and to avoid double counting of data

Join to prevent loops

Function in Framework manager

None of the above

Can be used for complex calculations

Can be used in Report Studio only

Can be used in Framework Manager only

Restricted to Bursting of reports

Used to show data from two or more queries in report studio

Pictorial representation of data

Used only in Query studio

Used only in Analysis Studio

Page explorer, Query Explorer and Conditional Explorer

Page Explorer, Internet explorer and Query Explorer

Query Explorer, Conditional Explorer and Analysis explorer

None of the above

Relationship between Fact and Dimension

Relationship between Dimension and Dimension

All the above

Relationship with tables from different data sources.

We cannot schedule the report more than once.

We cannot specify more than one format of the report output.

We cannot override the report output.

We cannot change the schedule once set.

None of the above.