Interested to Buy Any Domain ? << Click Here >> for more details...
scd methodology?
- 2 Answers
- 6276 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rr
SCD means slowly changing dimension.
It represents dimensions that change with time.
There are three types of scds.
Type1: Overwrite (contains no history)
Type2: Add an additional record with time stamp or flag
(contains history)
Type3: Add a new field for the record to represent the new
value(contains history)
| Is This Answer Correct ? | 1 Yes | 0 No |
Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.
Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.
Version:The changes made will be numbered as 0,1,2...so on.
Date:The changes along with the date in which they are made
are clearly mentioned.
Type3:The latest change which is made is alone available.
| Is This Answer Correct ? | 0 Yes | 0 No |
how tokens will generate?
How can u stop a batch?
In which transformation you cannot drag ports into it?
What are the ETL tools available in DWH?
What are the types of groups in Router transformation?
disable caching in a lookup transformation?
how to convert the .doc docs into .txt format using informatica
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
How you know when to use a static cache and dynamic cache in lookup transformation?
what are types of dimentions?
How can you differentiate between powercenter and power map?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Teradata 
