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...

What is degenerated dimention table?

Answer Posted / tamil

There few columns like, Invoice Number in Invoiceing Module
and Track number in Logistic modules and Vin Number in Car
manufacture module and some descriptions we can not
maintain in the dimensions since there could be huge number
of unique values. Insteade of mainitaing it in the
dimension, we would need to be place it in the associated
fact table for reporting purpose.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways to implement parallel processing in informatica?

1423


Explain about cumulative Sum or moving sum?

1043


How can you validate all mappings in the repository simultaneously?

1371


What is the need of an ETL tool?

1101


What is rank transform?

997


Define filter transformation?

1099


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2340


What is dynamic cache?

1036


Reusable transformation and shortcut differences

1840


Define mapping and session?

1038


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012


What are the types of data warehouses?

1526


What is aggregator transformation in informatica?

952


Describe data concatenation?

1082


What is a connected transformation?

1119