GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 8 of 327    Print  
can we update data into target without using update strategy transformation?

  
Total Answers and Comments: 5 Last Update: September 03, 2009     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
September 03, 2009 08:37:24   #5  
Sumithav29 Member Since: June 2009   Contribution: 11    

RE: can we update data into target without using update strategy transformation?
We can update the target table by using the update override in target definition. it will update based on non key columns.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape