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
- 35930 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
How an expression transformation differs from aggregator transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
Tell me about Propagate functions in informatica
What is the scenario which compels informatica server to reject files?
What is the sequence generator transformation in informatica?
Briefly describe lookup transformation?
Explain how to import oracle sequence into informatica?
How to use procedural logic inside infromatica?
What is decode in static cache?
how to load dimension table and fact table. plz tell me the steps.
What is meant by target load plan?
What is flashback table ? Advance thanks
What do you mean by worklet?
What is source qualifier transformation in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
