Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / purva
Slowly changing dimensions are dimension tables that have
slowly increasing dimension data, as well as updates to
existing dimensions.
Ex : if a person Mr. x is living in the city C1 has a
transaction in a bank and his details is maintained and
after some years he moves to city C4, that means he has his
new details develped but the bank need to maintain the
details i.e both c1 and c2 details ,the history has to be
maintained fully or sometimes partially , so in this cases
the necessity of SCD is required
When updating existing dimensions, you decide whether to
keep all historical dimension data, no historical data, or
just the current and previous versions of dimension data.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is joiner change?
Explain the types of lookup transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is native users?
What is the difference between source qualifier transformations source filter to filter transformation?
what is the -ve test case in your project.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Whats there in global repository
What are the different types of repositories created using informatica?
How to join three sources using joiner? Explain though mapping flow.
How to load a Dimension ? and how to load a fact table?
what is Active lock explain
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Different circumstance which drives informatica server to expel records?
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.
