Interested to Buy Any Domain ? << Click Here >> for more details...
What are Dimensions and various types of Dimensions?
- 3 Answers
- 42531 Views
- PayPal, TCS, I also Faced
- E-Mail Answers
Answer Posted / shashiall
Dimensions contains Textual attributes.
It is Wide not Deep.(whereas FACT is deep not wide)
about Dimensions..
The Slowly Changing Dimensions Wizard creates mappings to
load slowly changing dimension tables:
Type 1 Dimension mapping. Loads a slowly changing dimension
table by inserting new dimensions and overwriting existing
dimensions. Use this mapping when you do not want a history
of previous dimension data.
Type 2 Dimension/Version Data mapping. Loads a slowly
changing dimension table by inserting new and changed
dimensions using a version number and incremented primary
key to track changes. Use this mapping when you want to
keep a full history of dimension data and to track the
progression of changes.
Type 2 Dimension/Flag Current mapping. Loads a slowly
changing dimension table by inserting new and changed
dimensions using a flag to mark current dimension data and
an incremented primary key to track changes. Use this
mapping when you want to keep a full history of dimension
data, tracking the progression of changes while flagging
only the current dimension.
Type 2 Dimension/Effective Date Range mapping. Loads a
slowly changing dimension table by inserting new and
changed dimensions using a date range to define current
dimension data. Use this mapping when you want to keep a
full history of dimension data, tracking changes with an
exact effective date range.
Type 3 Dimension mapping. Loads a slowly changing dimension
table by inserting new dimensions and updating values in
existing dimensions. Use this mapping when you want to keep
the current and previous dimension values in your dimension
table.
apart from these: there are...
Confirmed dimensions
Junk Dimensions
Degenerated dimension
Thanks...
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
Where do we use mapping variables in informatica?
What is joiner change?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How does the aggregator transformation handle null values?
Why union transformation is an active transformation?
How to go to the older version for a mapping?
how to load rows into fact table in data warehouse
What is rank transformation?
What can we do to improve the performance of informatica aggregator transformation?
Is there any way to read the ms excel datas directly into informatica?
What is standalone command task?
What are ETL Tools?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
