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

Repository user profiles

0 Answers  

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

Explain scd type 3 through mapping.

0 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

How would you copy the content of one repository to another repository?

0 Answers  

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---