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
Can informatica load heterogeneous targets from heterogeneous sources?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to load last n records of file into target table - informatica
What is the use of target designer?
Informatica Checkpoints
How can you increase the performance in joiner transformation?
What is a code page?
can anyone explain me about retail domain project in informatica?
What is joiner transformation in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is option by which we can run all the sessions in a batch simultaneously?
what is Active lock explain
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
expain about the tune parameters?