Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for scds ?
- 3 Answers
- 8856 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 a parameter When and where do you them when does the value will be created
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
How do you change a non-reusable transformation to reusable transformation?
What all join we can perform in LOOKUP transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is junk dimention?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Explain lookup transformation source types in informatica
What is the exact difference b/w IN and EXIST in Oracle..?
What is A complex mapping?
Explain transaction control transformation in informatica
Teradata 
