scd methodology?
- 2 Answers
- 5227 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 do you create single lookup transformation using multiple tables?
can you please explain me pre session and post session options?
How to elaborate tracing level?
How can repository reports be accessed without sql or other transformations?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What do you mean incremental aggregation?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is lookup ?
What is the use of code page?
how you will maintain version?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Teradata 
