Answer / kshatri

There are again types of modeling:
Data modeling,
Dimension Modeling,
Multidimensional Modeling
Physical Model
Locial Model

Data Modeling: Data modeling is the process of designing a
data base model. In this data model data will be stored in
two types of table fact table, dimension table fact table
contains the transaction data, and dimension table contains
the master data

Dimensional Modeling: It is a logical design technique that
seeks to present the data in a standard, intuitive
framework that allows for high-performance access. There
are different data modelings concepts like ER Modeling
(Entity Relationship modeling), DM (Dimensional modeling),
Hierarchal Modelling, Network modelling.But popular are ER
and DM only

During the logical design phase, you defined a model for
your data warehouse consisting of entities, attributes, and
relationships. The entities are linked together using
relationships.

During the physical design process, you translate the
expected schemas into actual database structures. At this
time, you have to map:
• Entities to tables
• Relationships to foreign key constraints
• Attributes to columns
• Primary unique identifiers to primary key
constraints
• Unique identifiers to unique key constraints

Answer / pushparao

modeling is defined as to convert requirements of the business
users into technical structures.
1.conceptual modeling
2.logical modeling
3.physical modeling
example modeling tools:ERwin

What are the different types of Type2 dimension maping?

1 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---