Answer Posted / kamleshmishra291

SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));

Differentiate between sessions and batches?

965

---

How you prepared reports for OLAP?

1548

---

Explain sessions. Explain how batches are used to combine executions?

955

---

Define pmcmd command?

994

---

Different circumstance which drives informatica server to expel records?

919

---

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

1373

---

Under what condition selecting sorted input in aggregator may fail the session?

1060

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4039

---

How can we use mapping variables in informatica?

1004

---

Which development components of informatica have the highest usage?

988

---

What is Data Caches size?

1034

---

Differentiate between reusable transformation and mapplet.

1031

---

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

1999

---

What are roles and groups and benefits of using them?

993

---

What is the use of code page?

1013

---