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

How do you update the records with or without using update strategy?

Question Posted / juhi verma


How do you update the records with or without using update strategy?..

Answer / Amar Rathi

In Informatica, you can update records in a target table either with or without an update strategy.n
1. Using Update Strategy: This is recommended when dealing with large volumes of data as it allows for efficient handling of updates.n - Set the 'Update' option on your target table's load rule to enable this feature.n - The 'Update' strategy can perform operations like incrementing a counter, updating a timestamp, or applying business rules based on existing records.n
2. Without using an Update Strategy: This is useful when dealing with small volumes of data or when you don't need any complex operations during updates.n - Simply set the target table's load rule to 'Update' without specifying an update strategy.n - In this case, Informatica will perform a simple row-by-row comparison and replace existing records with new values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

What is workflow manager?

1 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

What are the types of schemas we have in data warehouse.

1 Answers  

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

How do you load unique records into one target table and duplicate records into a different target table?

1 Answers  

what are the limitation of sorter transformation?

2 Answers   TCS,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

What are the popular informatica products?

1 Answers  

What is the reusable transformation?

1 Answers  

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1 Answers  

Explain dynamic target flat file name generation in informatica

1 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories