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
Define enterprise data warehousing?
What is standalone command task?
Is it possible to create multiple domains on a single Informatica server?
What is an expression transformation?
How we can create indexes after completing the loan process?
What is a surrogate key?
How union transformation is used?
What is informatica powercenter repository?
What are active transformations.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How many ways are there to create ports?
How do you load unique records into one target table and duplicate records into a different target table?
What do you understand by term role-playing dimension?
What does update strategy mean, and what are the different option of it?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
