what is degenerated dimension
Answers were Sorted based on User's Feedback
Answer / usha
the dimension which is located in a fact table is know
degenerate dimension
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / renu
the dimension which has no dimension table of its own and is
derived from the fact table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / babu
A DIMENSION WHICH IS GENERATED BY AT RUN TIME IS CALLED AS
DEGENERATED DIMENSION.
EXMPL:INVOICE NUMBER.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prathap kumar chenna
a fact which contain key/value and which does not supports
any dimension
Ex: poly numbers %
invoice numbers .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gangadhar
Degenerated dimension means which derived from fact table and which does not have its own dimension table
Ex: Invoice Number
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / lokesh
in degenerative dimension all are factfactless that meons
only primarykeys will present
correct me if it is wrong
| Is This Answer Correct ? | 0 Yes | 2 No |
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Sequence generator, when you move from develoment to production how will you reset
difference between source based commit? and target based commit? which is better with respect to performance?
how to import multiple flat files in to single target where there is no common column in the flat files
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
why we r using presql&postsql in source qualifier?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
how we can load rejected record's at run time?(not through bad files)
replace multiple spaces with single space.
How do you update the records with or without using update strategy?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project