Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

what is the exact meaning of domain?

3 Answers  

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

What is an active transformation?

0 Answers   Informatica,

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

How to join three sources using joiner?

0 Answers  

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---