what we require for D.modelling?



what we require for D.modelling?..

Answer / 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

More Informatica Interview Questions

How to load time dimension?

1 Answers   Ford,


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


Can we override a native sql query within informatica?

0 Answers  






can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


What are mapplets?

0 Answers  


Reusable transformation and shortcut differences

0 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


Enlist few areas or real-time situations where informatica is required.

0 Answers  


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


Categories