Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 3 Answers
- 6857 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / usha
1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables
2.Junk Dimension:- the dimension which is used to cerate
junk attributes
3.Degenerated Dimension:- The dimension that are located
in fact table
4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.
Types
SCD type1
SCD type2
SCD type3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the different versions of informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
is it possible to index the data in cache of lkp transformation ?
How do you use reject loader.
What is DR strategy for Informatica project?
Under what condition selecting sorted input in aggregator may fail the session?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Describe data concatenation?
Explain informatica architecture - version 8 / 9
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is the hint? how to use it to reduce the query processing in program?
what is Active lock explain
