Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

According to his methodology what all you need before you build a datawarehouse

0 Answers  

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

Explain your project of banking domian.

0 Answers   Cap Gemini,

how to work with mapplet designer in informatica?

7 Answers  

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories