Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10994 Views
- I also Faced
- E-Mail Answers
Answer Posted / surya
slowly changing dimensions can be classified by three types.
1)Type1:In this dimension we can store only current data
and here insert are treated as inserts and updates are
treated as updates.
2)Type2:In this dimension we can store complete historic
data and it can divided into three types
a)Flag
b)Version
c)Date Range
But in type2 inserts are treated as inserts and updates are
treated as inserts.
3)Type3:In this dimension we can store One time historic
data with current data.Here also inserts are treated as
insert and updates are treated as updates.
It's depend upon the granularity of the organization.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
Define enterprise data warehousing?
What do you mean incremental aggregation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What does command task mean?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is union transformation?
How to do the error handling of if ur source is flatfiles?
what is Active lock explain
What is the need of an ETL tool?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is the hint? how to use it to reduce the query processing in program?
Does an informatica transformation support only aggregate expressions?
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?
How would you copy the content of one repository to another repository?
