Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Issue with Update override at Target table in Informatica.

Question Posted / mukeshb112

Answers were Sorted based on User's Feedback



Issue with Update override at Target table in Informatica...

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

Is This Answer Correct ?    0 Yes 0 No

Issue with Update override at Target table in Informatica...

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

What is target designer and target load order?

0 Answers  

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

What are the out put files that the informatica server creates during the session running?

2 Answers  

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

What is joiner change?

0 Answers  

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

What is Target Update Override? What is the Use ?

8 Answers   Patni,

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories