Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is data modelling? what are types of modelling?In
which suituation will use each one?

Question Posted / harish


what is data modelling? what are types of modelling?In which suituation will use each one?..

Answer / mike

Data modelling: It is the process of designing a a datamart
or dataware house. there are three phases in data modeling
1)conceptual designing:In this phase the database
architects and the managers will understand the client
requirements. After understanding the requirements they
will identify the attributes and entities(colomns and
tables)
2)Logical designing:In this phase the dimension tables and
the fact tables are identified and also the relation ship
between the fact and dimension tables will gets identified.
Now the schema looks like either a star or snowflake
schema. To perform logical designing we use data modelling
tools like ER STUDIO or ERWIN.
3)Physical designing: Once the logical designing is
approved by the client it will be converted in to physical
existance in the database.

Hope this helps

Is This Answer Correct ?    23 Yes 0 No

Post New Answer

More Informatica Interview Questions

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

What are the out put files that the informatica server creates during the session running?

2 Answers  

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

What are events in workflow manager?

1 Answers   Accenture, IBM,

Explain the types of lookup transformation?

0 Answers  

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

How union transformation is used?

0 Answers  

How can you differentiate between powercenter and power map?

0 Answers  

What are the features of complex mapping?

0 Answers  

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

What is the format of informatica objects in a repository?

0 Answers  

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

For more Informatica Interview Questions Click Here
Categories