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

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

What is powercenter on grid?

0 Answers  

---

What is the maplet?

0 Answers   Informatica,

---

why u go for dimensions ?

3 Answers   TCS,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

What is rank transformation?

0 Answers  

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---