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

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

why u go for dimensions ?

3 Answers   TCS,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

how to declare array in plsql?

1 Answers  

---