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 go to the older version for a mapping?

1153

---

Parameter and variable differences

2108

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1067

---

What do think which one is the better joiner or look up?

1242

---

What are junk dimensions?

1111

---

How to do unit testing in informatica?

1227

---

Have you worked with/created Parameter file

1710

---

What is union transformation in informatica?

1192

---

What is the difference between stop and abort in informatica

1142

---

Why do we need informatica?

1054

---

What is aggregate cache in aggregator transformation?

1201

---

How you prepared reports for OLAP?

1656

---

Write the program through which the records can be updated?

1053

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1144

---

What is the function of union transformation?

1201

---