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
- 36296 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
What are roles and groups and benefits of using them?
I have a flat file, want to reverse the contents of the flat file
What does “tail –f” command do and what is its use as an Informatica admin.
Why filter transformation is an active one?
What is a connected transformation?
What if the source is a flat-file?
What is the surrogate key?
what is the complex transformation you used in informatica
Did u used latest transformations of 8.6.0? for what?
What are the different lookup cache(s)?
How can we delete duplicate rows from flat files?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is meant by lookup transformation? Explain the types of lookup transformation?
What is status code in informatica?
Explain sessions. Explain how batches are used to combine executions?
