Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10897 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
is it possible to index the data in cache of lkp transformation ?
What is difference between a gateway node and worker node?
What is the sql query overwrite in source qualifier in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the different kinds of facts.
What is the use of target designer?
what is degenerated dimension?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the Rank index port in Rank transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
lookup transformation with screenshots
Reusable transformation and shortcut differences
How might one distinguish in the case of mapping is right or not without associating session?
How to implement security measures using repository manager?
What is the format of informatica objects in a repository?
