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

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 will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

how do u tune queries?

1 Answers  

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

Can you copy the batches?

3 Answers  

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---