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

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

Can u generate reports in Informatica?

0 Answers   Informatica,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

What is rank transform?

0 Answers  

---

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

---

how do u move the code from development to production?

6 Answers  

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

---

what is parameter file?

1 Answers   Cap Gemini,

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---