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

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

What is Index Caches size?

0 Answers   Informatica,

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---