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
What is session task and command task?
How to update a particular record in target with out running whole workflow?
what is the size of u r source(like file or table)?
Explain lookup transformation source types in informatica
What are Dimensional table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What do you understand by term role-playing dimension?
What is informatica worklet?
Explain pmcmd command usage in informatica
What is complex mapping?
What are the tasks that can be performed using sq?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How do you update the records with or without using update strategy?
How can we update a record in the target table without using update strategy?