Answer / santosh kumar sarangi

:TU means data coming as input to target.

Just use the query in pre or post sql in target or session.

Let me know if any thing wrong.

Thanks & regards
Santosh kumar Sarangi

Answer / 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

In which scenario did you used pushdown optimization?

1 Answers  

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

Types of error logs in Informatica?

2 Answers  

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

What is a standalone command task?

0 Answers  

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

How do you use reject loader.

0 Answers  

---

in static and dynamic which one is better

2 Answers  

---