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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is intricate mapping?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to improve the performance of a session using sorter transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain why we use partitioning the session in informatica?
On which transformations you created partitions in your project?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can we use batches?
What are the modules in Power Center
Explain sql transformation in script mode examples in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the mapping variable usage example in informatica
