Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradeep
scd-slowly changing dimension
It is the capturing the slowly changing data which changes
very slowly with respect to the time. for example: the
address of a custumer may change in rare case. the address
of a custumer never changes frequently.
there are 3 types of scd. type1 - here the most recent
changed data is stored
type2- here the recent data as well as all past data
(historical data) is stored
trpe3- here partially historical data and recent data are
stored. it mean it stores most recent update and most recent
history.
As datawarehouse is a historical data, so type2 is more
usefull for it.
(welcome new answers)
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
What are the uses of etl tools?
COM components can be used in Informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
As union transformation gives UNION ALL output, how you will get the UNION output?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Did u used latest transformations of 8.6.0? for what?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is a grid in Informatica?
What are multi-group transformations?
wf dont have integration severances how you can run?
How can we create index after completion of load process?
How to load last n records of file into target table - informatica
What is a stored procedure transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
