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

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3513


Where are the source flat files kept before running the session?

626


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

558


Plz can any one say me how to get the informatica certification materials and dumps

1600


What are the settings that you use to configure the joiner transformation?

613






What is workflow? What are the components of workflow manager?

711


Explain sessions. Explain how batches are used to combine executions?

597


What do you understand by a term domain?

670


What is the need for an etl tool?

640


what is diff b/t sorter t/r and agg have the option sorter property...

1748


What is the commit type if you have a transaction control transformation in the mapping?

654


Explain lookup transformation is active in informatica

662


generate date / time dimension in informatica

721


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1626


How do you remove duplicate records in informatica? And how many ways are there to do it?

715