Answer Posted / 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 |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you load unique records into one target table and duplicate records into a different target table?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is the size of u r source(like file or table)?
How to do the error handling of if ur source is flatfiles?
Briefly explain the aggregator transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is InformaticaPowerCenter?
What is domain in terms of informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Where do we use mapping variables in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the advantages of informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?