Interested to Buy Any Domain ? << Click Here >> for more details...
scd methodology?
- 2 Answers
- 6176 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 |
What is aggregate cache in aggregator transformation?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
What is the meaning of decode in informatica?
if i am having 10 records in source, i want 20 records in target...how will you do it
What are the restrictions of union transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Does an informatica transformation support only aggregate expressions?
what r the values tht r passed between informatics server and stored procedure?
what is target load plan
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Teradata 
