Issue with Update override at Target table in Informatica.
Answers were Sorted based on User's Feedback
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 |
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 |
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What is complex mapping?
what is the hint? how to use it to reduce the query processing in program?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
what is metadata?
What is the term PIPELINE in informatica ?
I have 1200 records how can u send it in aggregator with good performance issues?
what is the size of u r project? and what is the size of source file?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
Performance tuning in UNIX for informatica mappings?
Different qualification between a related rotate toward the sky and isolates look upward?