What are slowly changing dimensions?
- 5 Answers
- 28793 Views
- Informatica, Verinon Technology Solutions, I also Faced
- E-Mail Answers
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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you load only null records into target?
wf dont have integration severances how you can run?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the use of target designer?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are ETL Tools?
What is an Integration service in Informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
4 yrs etl devloper roles and responsibilities?any body give solutions
how to load dimension table and fact table. plz tell me the steps.
How many numbers of sessions can one group in batches?
Where are the source flat files kept before running the session?
Slowly changing dimensions, types and where will you use them
How to implement security measures using repository manager?
