Answer Posted / kamleshmishra291

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

Describe an informatica powercenter?

602

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1312

---

can we override a native sql query within informatica? How do we do it?

643

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1511

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

635

---

---

what is song in infrmatica...?

1670

---

Tell me about Propagate functions in informatica

520

---

Different qualification between a related rotate toward the sky and isolates look upward?

547

---

State the differences between sql override and lookup override?

615

---

Define filter transformation?

619

---

Where are the source flat files kept before running the session?

622

---

What does “tail –f” command do and what is its use as an Informatica admin.

627

---

Difference between Target-based loading and constraint-based loading?

548

---

Could you explain what is enterprise data warehouse?

551

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1547

---