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
is it possible to index the data in cache of lkp transformation ?
Write the advantages of partitioning a session?
What is blocking transformation?
what are the deliverables?in your project?
While migrating the data from one environment to another environment how would you manage the connections?
How to extract the informatica rejected data?
What are the different components of powercenter?
How union transformation is used?
What is an active transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the advantage of informatica?
What are the main features of Oracle 8i with context to datawarehouse?
What is target designer and target load order?
What are the types of lookup transformation?
How can a transformation be made reusable?