Answer Posted / moorthy g

It Displays the following Messages:
>> select moorthy+1 from dual

ERROR at line 1:
ORA-00904: "MOORTHY": invalid identifier

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6073

---

What is main use of mapplet?

1088

---

Is there any way to read the ms excel datas directly into informatica?

993

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1861

---

What is dynamic cache?

991

---

what is index?how it can work in informatica

1997

---

What is meant by lookup transformation? Explain the types of lookup transformation?

910

---

Enlist the advantages of informatica.

1018

---

what is informatica metadata?

991

---

What is standalone command task?

1280

---

Explain joiner transformation in informatica

1094

---

What is the command used to run a batch?

1016

---

What is fact table? Explain the different kinds of facts.

1028

---

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?

1466

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2041

---