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
- 36163 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 is a predefined event?
How do you update the records with or without using update strategy?
Clarify the aggregator change?
scenario where i can use only concurrent execution of workflow.
permutations of mapplet
How can we use mapping variables in informatica?
What is meant by target load plan?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to go to the older version for a mapping?
What do you understand by term role-playing dimension?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can informatica load heterogeneous targets from heterogeneous sources?
Explain direct and indirect flat file loading (source file type) - informatica
What is session task and command task?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
