Interested to Buy Any Domain ? << Click Here >> for more details...
scd methodology?
- 2 Answers
- 6189 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 diffrence b/w joner and union transfermation
what is normalizer transformation?
How to fix the etl bugs..Tell me the process?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of maping in Getting Started Wizard?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
What are the associated ports in look up T/R.
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What are parallel querys and query hints?
Teradata 
