GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 8 of 303    Print  
can we update data into target without using update strategy transformation?

  
Total Answers and Comments: 4 Last Update: April 19, 2007     Asked by: dwhprofessional 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 31, 2006 05:36:43   #1  
Jagadeesh        

RE: can we update data into target without using updat...

Y not.... U can still update data in target using session Properties

Usage of update strategy is only overriding existing functionality of session update stratgy information...

So no need of using update strategy in your particular scenario

From

Jagadeesh


 
Is this answer useful? Yes | No
April 11, 2006 07:43:37   #2  
SuvarnaP        

RE: can we update data into target without using updat...
Please explain in more detail How to do this?
 
Is this answer useful? Yes | No
April 13, 2006 14:45:08   #3  
sunil        

RE: can we update data into target without using updat...

Go to session properties..u have an option treat source rows as...

ther u can select it as update or insert

if you use..update strategy by default at session properties--treat source rows as --data driven is selected


 
Is this answer useful? Yes | No
April 19, 2007 01:37:02   #4  
Ravichandra        

RE: can we update data into target without using updat...
In Session properties SELECT treat source rows as UPDATE

In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape