binoy_pa

 Profile Answers by binoy_pa Questions by binoy_pa

• Apr 17th, 2006

 

confirmed dimension ==  one  dimension  that  shares with  two fact table

factless   means  ,fact table  without   measures  only  contains  foreign  keys-two  types  of  factless  table   ,one  is  event  tracking   and  other  is   covergae  table

Bit map  indexes  preffered  in  the  data ware  housing

Metedata  is  data  about  data,  here  every  thing  is  stored  example-mapping,sessions,privileges  other  data,in  informatica  we  can   see  the  metedata  in    the   repository.

System  catalog  that  we   used  in  the   cognos,that   also  contains   data,tables,privileges,predefined   filter  etc,  using  this   catalog  we   generate  reports

group  cross  tab  is   a  type   of   report  in  cognos,where  we   have  to assign 3  measures  for  getting   the   result

Mehul Thakkar

• Apr 18th, 2006

 

Hi Bin,

I doubt your answer about the Grouped Cross Tab, where you said 3 measure are to be specified, which i feel is wrong.

I think that grouped cross tab has only one measure, but the side and row headers are grouped like

                          India              China

                      Mah | Goa        XYZ | PQR          

2000                20K   30K         45K    55K

2001                39K    60K        34K    66K

Here the cross tab is grouped on Country, and then State.

Similary even we can go further to drill year to Quarters.

And this is known gruped Cross tab.

     

       

Arun

• May 25th, 2006

 

The cursor which is not declared in the declaration section but in executable section where we can give the table name dynamically there.so that the cursor can fetch the data from that table

Siva

• Jun 18th, 2006

 

grouped cross tab is the single report which contains number of crosstab report based on the grouped items. like

Here countries are groupe items.

INDIA

	M1	M2
Banglore	542	542
Hyderabad	255	458
Chennai	45	254

 

 

 

 

 

USA

	M1	M2
LA	578	5876
Chicago	4785	546
Washington DC	548	556

 

 

PAKISTAN

	M1	M2
Lahore	457	875
Karachi	458	687
Islamabad	7894	64

 Thanks

                 

 

 

 

Prasad

• Jul 14th, 2006

 

Hi,

Rest of the answers are given by friends earlier.

DSS->Decision Support System.

The purpose of a DWH is to provide users data through which they can make their critical besiness decisions.

DSS data base is nothing but a DWH. OLAP tools obviously use data from a DWH which is transformed to generate reports. These reports are used by the users, analysts to extract strategic information which helps in decision making.

Pavan Amaraneni

• Nov 24th, 2006

 

The Default Index type for DWH is bitmap(non-unique)index