in which situations do u go for scds ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / murali
Mr.Chandra,
SCD's are the essential mappings we need to useto maintain
Datawarehouses. Coz,if we are serving our clients with
maintainance, we ought to update their data with necessary
changes. the changes can be,
1. Inserting the data from the latest OLTP database
2. Updating our OLAP DWH with changes.
3. Maintaing the change, as well as Historical data etc...
All these, can be done using SCD's only...
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rajan raorane
SCDs are basically used to updates in existing data or to
maintain history Data along with existing one
Is This Answer Correct ? | 1 Yes | 0 No |
select count(1) from emp? what is the o/p?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
What are the types of schemas we have in data warehouse and what are the difference between them?
what are the row and column separations in Flat Files
How can we eliminate duplicate rows from flatfile,explain?
Write the unconnected lookup syntax?
To import the flat file definition into the designer where should the flat file be placed?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
How can a transformation be made reusable?
How to use Normalizer transformation?