What is degenerated dimention table?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / seetharam
The dimension keys which are directly cming from the oltp
system with out any associated dimension to the fact table
.These are called degenerate dim or line item dimensions
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pintu
IS it degenetrated dimension? Or,degenetrated dimension
table?
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / uppala chary
The dimension which is not connected to any of the fact tble but key
exists in the fact table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sujana
it is generated at runtime..acts as pk in fact table..
Is This Answer Correct ? | 0 Yes | 2 No |
When do you use mapping parameters? (In which transformations)
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to display First letter of Names in Caps?
What is confirmed fact in dataware housing?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is domain and gateway node?
can we override a native sql query within informatica? How do we do it?