Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10829 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
State the limitations where we cannot use joiner in the mapping pipeline?
Explain lookup transformation is active in informatica
waht type of interface is used for testing the data in informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
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.
Why do you use Mapping Parameter and mapping variable?
what is Active lock explain
can u any challenge your project?
What are the guidelines to be followed while using union transformation?
What do you mean by worklet?
what is the difference between informatica6.1 and infomatica7.1
What is pmcmd command?
How we can use union transformation?
How do you migrate data from one environment to another?
What is an aggregator transformation?
