Answer Posted / kamleshmishra291

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

What is incremental aggregation?

1038

---

Write the prerequisite tasks to achieve the session partition?

1098

---

What is rank index in rank transformation?

1029

---

What is workflow? What are the components of workflow manager?

1142

---

What is mapping debugger?

966

---

How to generate sequence numbers?

1043

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1238

---

What is informatica powercenter repository?

1154

---

What is an expression transformation?

983

---

What are the components of workflow manager?

1042

---

Explain pmcmd command usage in informatica

1085

---

What is the scenario which compels informatica server to reject files?

1024

---

Name the different lookup cache(s)?

1173

---

How do we call shell scripts from informatica?

1039

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2271

---