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

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6356

---

What is Index Caches size?

1055

---

What do you mean by enterprise data warehousing?

1002

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1846

---

What are the popular informatica products?

958

---

Do you find any difficulty while working with flat files as source and target?

1051

---

What is the function of union transformation?

1063

---

what is SDLC way of code development?

1967

---

expain about the tune parameters?

2338

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1604

---

What can we do to improve the performance of informatica aggregator transformation?

1042

---

What is repository manager?

930

---

Explain the different lookup methods used in informatica?

973

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1997

---

How are indexes created after completing the load process?

1545

---