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
Explain why we use partitioning the session in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What are the components of the workflow manager?
Is there any target staging area in informatica not staging area
What are the restrictions of union transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are some examples of informatica etl programs?
What is a sorter transformation?
What is meant by lookup transformation?
what are the deliverables?in your project?
What is rank transformation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Write the different tools in the workflow manager?
What is lookup change?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?