Answer Posted / hardeep

Hi Pooja

Thanks for reply but could u pls explain more what type of dimensions are called as monster dimensions... Properties of Monster Dimensions.

Hardeep

Different circumstance which drives informatica server to expel records?

1043

---

What is the difference between a connected look up and unconnected lookup?

1003

---

How we can create indexes after completing the loan process?

1252

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

How you prepared reports for OLAP?

1659

---

How to create a non-reusable instance of reusable transformations?

1170

---

What are session parameters ? How do you set them?

1901

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

---

Can we override a native sql query within informatica?

1092

---

What do you mean by blocking transformation?

1119

---

What is a joiner transformation and why it is an active one?

1165

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2073

---

How to load a Dimension ? and how to load a fact table?

1465

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2085

---

How do you update the records with or without using update strategy?

1164

---