Answer Posted / sujatha

Hi,

Hints are used to improve the query performance. Please go
through the below link ...u will get all the info
required...
http://www.adp-gmbh.ch/ora/sql/hints/index.html

What is dimensional table?

1060

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

---

Can we override a native sql query within informatica?

1034

---

What is InformaticaPowerCenter?

1129

---

How are indexes created after completing the load process?

1637

---

What is the fact table?

1062

---

How you prepared reports for OLAP?

1594

---

What is lookup transformation?

1038

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1506

---

How to elaborate powercenter integration service?

1129

---

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

2391

---

What are the informatica performance improvement tips

1089

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2718

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2063

---