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

What is dynamic cache?

0 Answers  


How will you convert rows into columns or columns into rows

1 Answers  


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  


WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,






which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,


What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


What is a joiner transformation?

0 Answers  


what is the method of error handling when session is running?

1 Answers   TCS,


What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,


Categories