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

Can you define bitmap index?

0 Answers  

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

what is surrogate key give example?

2 Answers  

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 Answers  

what is the difference between cognos8 fm and cognos reportnet fm?

1 Answers  

Can you define cognos decision stream?

0 Answers  

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 Answers  

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,

What is metric store database?

0 Answers  

what is the procedure for scheduling conditional rendering?

0 Answers   Syntel,

For more Cognos Interview Questions Click Here
Categories