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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

551

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1761

---

Explain what is informatica metadata and where is it stored?

606

---

what are the deliverables?in your project?

1655

---

What are the differences between source qualifier and joiner transformation?

598

---

---

Explain target update override in informatica

630

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

610

---

What are the new features of informatica 9.x at the developer level?

602

---

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

1728

---

How can you increase the performance in joiner transformation?

708

---

How to load data in informatica ?

570

---

What is rank transformation in informatica

689

---

What is expression transformation?

630

---

can u give example for factless fact table

5516

---

how to load dimension table and fact table. plz tell me the steps.

1683

---