Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Update strategy transformation

This is a discussion on Update strategy transformation within the Data Warehousing forums, part of the Databases category; I am trying to insert an update a target table using update strategy transformation. It works fine when all the records in tha target have to be updated or all ...

Geeks Talk > Databases > Data Warehousing Update strategy transformation

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   01-09-2007

JobHelper Expert Member   Join Date: Oct 2006 Posts: 690 Thanks: 0 Thanked 49 Times in 41 Posts

Update strategy transformation I am trying to insert an update a target table using update strategy transformation. It works fine when all the records in tha target have to be updated or all the records in the target have to inserted.But it fails when few records are to be updated and few to be inserted NOTE : [This question was asked by a visitor]

Sponsored Links

#2 (permalink)   02-03-2007

sat.inn Junior Member   Join Date: Feb 2007 Location: india Posts: 7 Thanks: 0 Thanked 1 Time in 1 Post

Re: Update strategy transformation hi! edit sessoin--->give insert and update as update in the target load option. hope ur problem wil be solved

Geeks Talk > Databases > Data Warehousing

« remove duplicate values in a source using Informatica | Data warehousing articles »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Column to row transformation	JobHelper	Data Warehousing	2	01-18-2008 08:27 AM
Test cases Strategy	rose	Test Cases	6	03-01-2007 03:26 AM
Application source qualifier transformation	Lokesh M	Data Warehousing	0	12-08-2006 06:14 AM
Kindly update me the Limitations	christia	Unix/Linux	1	09-13-2006 12:33 PM
Kindly update me the use of this Program	Remasri	Unix/Linux	1	08-11-2006 05:14 AM

All times are GMT -4. The time now is 02:48 PM.