scd methodology?
- 2 Answers
- 5312 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 |
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
which transformation uses cache?
How to generate sequence numbers without using the sequence generator transformation?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
where to select code page option?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
how to design mapping half of source table records into one target and remaining half into another target
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Do you have to change the reject file b4 using reject loader utility.
Insert else update option in which situation we will use
What are Rapid changing dimensions?
Teradata 
