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 >> Data Stage
  2. Suggest New Category

what are fact tables and dimension tables?
give example assuming one table.

Question Posted / sri.gullapalli

Answers were Sorted based on User's Feedback



what are fact tables and dimension tables? give example assuming one table...

Answer / srikanth

Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.

Is This Answer Correct ?    1 Yes 0 No

what are fact tables and dimension tables? give example assuming one table...

Answer / kathyayini

fact table is the collection of foriegn keys corresponding
primary keys in the dimention tables


dimention table is the table which contains primary key and
will give detail informati1on about perticular instance

Is This Answer Correct ?    0 Yes 1 No

what are fact tables and dimension tables? give example assuming one table...

Answer / ramesh

A Fact table is a table that contains the measures of
intersert.
A dimensional table is a collection of hierarchies and
categories along which the user can drill down and drill
up. it contains only the textual attributes.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Data Stage Interview Questions

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

tell me abt Datastage trigger?

1 Answers   HP, IBM,

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

What are routines in datastage? Enlist various types of routines.

0 Answers  

What are the difference types of stages?

0 Answers  

How can you join flat file, oracle as a sources?

4 Answers   IBM,

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

For more Data Stage Interview Questions Click Here
Categories