Answer Posted / vaibhav bhandeo
Data modelling requires understanding of the requirements.
In general the design of data model can be a snowflake
(Highly normalized) or star schema (partial or not
normalized) which depends on whether you want optimal
utilization of space (Use star schema) or you want a
normalized data model easy to query and acess data (Use
snow flake).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
How can we delete duplicate rows from flat files?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
COM components can be used in Informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is degenerated dimension?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain sessions?
What is the procedure for creating independent data marts from informatica 7.1?
Explain pushdown optimization and types in informatica
What are the new features of informatica 9.x developer?
Which files are created during the session rums by informatics server?
Is there any way to read the ms excel datas directly into informatica?
What is a filter transformation?