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

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

Quickly characterize reusable change?

0 Answers  

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

what is difference between mapping and mapplet ?

2 Answers   TCS,

How can we delete duplicate rows from flat files?

0 Answers  

Can we make worklet inside worklet?

1 Answers  

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

For more Informatica Interview Questions Click Here
Categories