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, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
How we can confirm all mappings in the repository simultaneously?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
What do think which one is the better joiner or look up?
what are objects in data warehouse?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What does update strategy mean, and what are the different option of it?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is partioning?how many types of partinings are there
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is xml source qualifier transformation in informatica?
Define Incremental Aggregation?