Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

which table we load first in DW. dimension or fact? why?

Question Posted / imran

Answers were Sorted based on User's Feedback



which table we load first in DW. dimension or fact? why?..

Answer / asish mohapatra

We should first load dimension table then the fact table .

Is This Answer Correct ?    8 Yes 0 No

which table we load first in DW. dimension or fact? why?..

Answer / mahesh225

Dimension tables will be loaded first.

www.futuresoftworld.com
www.futureitem.com

Is This Answer Correct ?    5 Yes 0 No

which table we load first in DW. dimension or fact? why?..

Answer / krishna

First we load dimension and next fact. Without dimension table there is no meaning for fact table.

Is This Answer Correct ?    1 Yes 0 No

which table we load first in DW. dimension or fact? why?..

Answer / adnan

Fact table has foreign keys referencing the primary key of dimension.
Logically Foreign key is a subset of primary or unique key. That's why , we
need to load dimension tables first and then to load fact tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

why u need to publish the package?

5 Answers   IBM,

what is loop in frameworkmanager ?

4 Answers   Texas,

How to create Events?

1 Answers  

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.

3 Answers   Kudos India,

what is an associated query?

2 Answers  

write a query to display the departments with no employee?

0 Answers   HCL,

What are all the types of report?

0 Answers  

------------------What is Inline Query?

0 Answers   Cap Gemini,

What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

2 Answers   TCS, Tech Mahindra,

What is defined as Query studio?

0 Answers  

What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  

For more Cognos Interview Questions Click Here
Categories