Interested to Buy Any Domain ? << Click Here >> for more details...
What are the mapings that we use for slowly changing
dimension table?
- 2 Answers
- 10744 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
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain what is informatica metadata and where is it stored?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a filter transformation and why it is an active one?
What is intricate mapping?
Write the advantages of partitioning a session?
What are the types of caches in lookup?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How do you handle two sessions in Informatica
How do you promote a non-reusable transformation to reusable transformation?
What do you mean by enterprise data warehousing?
Whats there in global repository
Explain the aggregator transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the function of union transformation?
