What are slowly changing dimensions?
Answer Posted / sandeep.t nizamabad
DIMENSIONS ARE CLASSIFIED INTO THREE TYPES
SCD TYPE-1 (MAINTAIN CURRENT DATA)
SCD TYPE-2 (MAINTAIN CURRENT DATA+FULL HISTORY OF CHANGES)
SCD TYPE-3 (MAINTAIN CURRENT DATA+ONE TIME HISTORY)
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between source qualifier and filter transformation?
What is sq transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is sequence generator transformation in informatica?
How you prepared reports for OLAP?
What is xml source qualifier transformation in informatica?
What is the Rank index port in Rank transformation?
Why do you use Mapping Parameter and mapping variable?
What is a rank transform?
What is a snowflake schema?
What are the designer tools for creating transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
wf dont have integration severances how you can run?
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