Answer Posted / mukeshb112

There is some issue with Update override.
Default query is:
UPDATE EMPTGT SET ENAME = :TU.ENAME, JOB = :TU.JOB, MGR
= :TU.MGR, HIREDATE = :TU.HIREDATE, SAL = :TU.SAL, COMM
= :TU.COMM, DEPTNO = :TU.DEPTNO WHERE EMPNO = :TU.EMPNO

and I don't want to update all columns so I delete others

My query is

UPDATE EMPTGT SET SAL = 500
WHERE EMPNO = 7900

There is primary key as Empno.
I want to know where is issue in my query.
and what does mean by " :TU " in default query.

Thanks and regards
Mukesh

How to extract sap data using informatica?

1009

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1451

---

Could you explain what is enterprise data warehouse?

1079

---

Can we get 1st record through Informatica(without sequence number).

1431

---

What is the reusable transformation?

1019

---

What are the prerequisite tasks to achieve the session partition?

1203

---

What is the meaning of up gradation of repository?

1921

---

Design time, run time. If you don't create parameter what will happen

1814

---

What is workflow manager?

1006

---

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

---

Explain about Informatica server process that how it works relates to mapping variables?

1029

---

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

1088

---

What are the various types of transformation?

1119

---

Explain load alternative records / rows into multiple targets - informatica

1115

---

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

1238

---