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 |
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Which kind of index is preferred in DWH?
Without using any transformations how u can load the data into target?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
What is Code Page Compatibility?
how can you load data into target table without leading zeor's
What is galaxy shema
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.