Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for scds ?
- 3 Answers
- 9147 Views
- TCS, I also Faced
- E-Mail Answers
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 |
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
How to get EVEN & ODD numbers separately?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What is decode in informatica?
What is the difference between Normal load and Bulk load?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
In dimension and fact table? which one holds big data?
Which is better performance wise database or file?How?
Differentiate between a repository server and a powerhouse?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Teradata 
