Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 4 Answers
- 36095 Views
- IBM, Infotech, I also Faced
- E-Mail Answers
Answer Posted / msr
1.A dimension table which can be shared by multiple fact
tables is know as confirmed dimension.
2.A junk diemesion with type discriptive data boolean , flag
datatype can't be used to discribed the key performance
integrator are know as junk dimension for
exple:productdiscription,address,zipcode,phone number
if a table contains the values which are neither dimension nor
measure is called degenerate dimensions for
exple:invoice-id,empno
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Informatica settings are available in which file?
differences between service based and product based?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is native users?
What is target designer and target load order?
Make a note of the quantity vaults made in informatica?
How to generate sequence numbers without using the sequence generator transformation?
Under which circumstances, informatica server creates reject files?
which one is better performance wise joiner or look up
What is the meaning of up gradation of repository?
Explain the different kinds of facts.
What is a surrogate key?
Why is sorter an active transformation?
How do you use reject loader.
