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 the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

Can you use flat files in Mapplets.

0 Answers  

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

What is complex mapping?

0 Answers  

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

List the transformation in informatica.

1 Answers   TCS,

---

what is workflow varible

1 Answers   HP,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

how to sort date field in infomatica?

2 Answers  

---

According to his methodology what all you need before you build a datawarehouse

0 Answers  

---