1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to update a particular record in target with out running whole workflow?

Question Posted / tharun reddy


How to update a particular record in target with out running whole workflow?..

Answer / Akanksha Lohia

In Informatica, you can use the Update Subroutine Transformation or the Update Data Mark transformation to update specific records in the target without triggering the entire workflow. The Update Subroutine Transformation allows you to write custom PL/SQL code for handling updates, while the Update Data Mark transformation marks rows for update based on a condition.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1 Answers   TCS,

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

without update strategy how to insert &update?

1 Answers   DELL,

What is InformaticaPowerCenter?

1 Answers   Informatica,

Explain the code page compatibility?

1 Answers  

Explain the difference between mapping parameter and mapping variable?

1 Answers  

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

what is session parameters?

1 Answers   Cap Gemini,

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories