Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are active and passive transformations?
How can you validate all mappings in the repository simultaneously?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to create user defined function (udf) in informatica
How to open an older version of an object in the workspace?
What are the components of Informatica? And what is the purpose of each?
How do we call shell scripts from informatica?
Where can we find the throughput option in informatica?
permutations of mapplet
Why update strategy and union transformations are active? Explain with examples.
Explain direct and indirect flat file loading (source file type) - informatica
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is informatica metadata?
Describe the impact of several join conditions and join order in a joiner transformation?
