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
- 36302 Views
- IBM, Infotech, I also Faced
- E-Mail Answers
Answer Posted / deepthi
Few more additions to the above answers.....
Confirmed dimension: Dimesion which can be 100 % sharable
with other star schemas. In other terms it is connected to
more than one one fact table .
Ex: time dimension
Junk dimesion: stores low cordinality values (repeated
values),flagged values.
Ex: details of gender information(male/female)
Degenerated Dimension:The attribute in the fact table
directly comes from the source table not from any
dimensions called degenerated dimensions. these are also
called neither a dimension nor a perfect fact.
Ex:attribute order_no, comes from source
Slowly changing Dimensions:Dimesions which are changing
over a period of time called slowly changing dimensions.
Ex:salary of employee.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you change a non-reusable transformation to reusable transformation?
What is the difference between stop and abort in informatica
What do think which one is the better joiner or look up?
Can anyone tell me the new features in Informatica 9 Version?
In informatics server which files are created during the session rums?
Please let me know how to make encryption and decryption with example?
What can we do to improve the performance of informatica aggregator transformation?
can we override a native sql query within informatica? Where do we do it?
What is the surrogate key?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the various types of transformation?
Where can we find the throughput option in informatica?
Write the unconnected lookup syntax?
Why update strategy and union transformations are active?
