Register or Login. Welcome back! Sign in with Email. Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign up with Email. Sign in with email Enter the email address associated with your account. Facebook Twitter. Update strategy transformation is an active and connected transformation. Update strategy transformation is used to insert, update, and delete records in the target table.
It can also reject the records without reaching the target table. When you design a target table, you need to decide what data should be stored in the target. When you want to maintain a history or source in the target table, then for every change in the source record you want to insert a new record in the target table. When you want an exact copy of source data to be maintained in the target table, then if the source data changes you have to update the corresponding records in the target.
The design of the target table decides how to handle the changes to existing rows. Informatica - DTM Threads. Informatica - Load Balancing. Different ETL tools in Informatica. What is Mapping architect for Visio? Informatica - PowerCenter Informatica - Creating Integration Service. Creating Informatica Repository Service. Configuring Client Domain in Informatica. Creating Source Analyzer in Informatica. Creating Target designer in Informatica. Create Users and Folders in Informatica. Setting up Target Database in Informatica.
Learn and Create Workflows in Informatica. Learn and Create Mapping in Informatica. Learn and Create a session in Informatica. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 0.
0コメント