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

What do you mean by enterprise data warehousing?

1056

---

what are the Methods For Creating Reusable Transformations?

1162

---

How many types of sessions are there in informatica.please explain them?

1158

---

update strategy transformation in informatica

1060

---

where to store informatica rejected data?

1091

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1865

---

How can we delete duplicate rows from flat files?

1211

---

Why do we need informatica?

982

---

Can we override a native sql query within informatica?

1031

---

Explain incremental aggregation in informatica

1114

---

How you can differentiate between connected lookup and unconnected lookup?

1054

---

What is meant by incremental aggregation?

1095

---

How can you generate reports in informatica?

1018

---

How to open an older version of an object in the workspace?

1196

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2200

---