Answer Posted / msr

1.A dimension table which can be shared by multiple fact
tables is know as confirmed dimension.

2.A junk diemesion with type discriptive data boolean , flag
datatype can't be used to discribed the key performance
integrator are know as junk dimension for
exple:productdiscription,address,zipcode,phone number

if a table contains the values which are neither dimension nor
measure is called degenerate dimensions for
exple:invoice-id,empno

What are active and passive transformations?

1081

---

What are the data movement modes in informatica?

1152

---

what is the size of your data warehousing?

2095

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1776

---

Briefly explain the aggregator transformation?

1008

---

How do you take back up of repository?

1160

---

What is a dimensional model?

978

---

Target increases every day even though no new record was inserted

1580

---

What is domain in terms of informatica?

1007

---

how to load rows into fact table in data warehouse

1188

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068

---

What is meant by LDAP users?

1208

---

Define pmcmd command?

1039

---

How to use pmcmd utility command?

1032

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2192

---