with out using update strategy transnsformation how to
update the data in mapping level



with out using update strategy transnsformation how to update the data in mapping level..

Answer / guest

By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

Is there any target staging area in informatica not staging area

0 Answers   Syntel,


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


In update strategy target table or flat file which gives more performance ? why?

7 Answers  


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,






What are the parts of Informatica Server?

1 Answers   Cognizant,


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,


What is the meaning of decode in informatica?

0 Answers  


What is a node in Informatica?

0 Answers  


what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


What is status code in informatica?

0 Answers  


Categories