Answer Posted / yugan

no.it won't support oracle keywords.infact it wil throw an
error.

Explain the different kinds of facts.

946

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2262

---

Why update strategy and union transformations are active?

1003

---

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

1739

---

What is aggregate cache in aggregator transformation?

1081

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1210

---

design of staging area?

1978

---

How to delete duplicate row using informatica?

996

---

How to generate sequence numbers without using the sequence generator transformation?

1148

---

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?

1456

---

What is workflow manager?

1003

---

How can we use batches?

978

---

What is olap (on-line analytical processing?

1023

---

What do you understand by a term domain?

1083

---