Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / purva
Slowly changing dimensions are dimension tables that have
slowly increasing dimension data, as well as updates to
existing dimensions.
Ex : if a person Mr. x is living in the city C1 has a
transaction in a bank and his details is maintained and
after some years he moves to city C4, that means he has his
new details develped but the bank need to maintain the
details i.e both c1 and c2 details ,the history has to be
maintained fully or sometimes partially , so in this cases
the necessity of SCD is required
When updating existing dimensions, you decide whether to
keep all historical dimension data, no historical data, or
just the current and previous versions of dimension data.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
wat are deployement groups in informatica, how it will be used for developers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the designer tools for creating transformations?
What is standalone command task?
What is data transformation manager process?
How big was your fact table
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
can we override a native sql query within informatica? How do we do it?
What is an Integration service in Informatica?
server hot-ws270 is connect to Repository B. What does it mean?
What are the new features of informatica 9.x at the developer level?
What are the types of lookup transformation?
