GeekInterview.com
Series: Subject: Topic:
Question: 208 of 726

Can we update target table without using update strategy transformation? why?

Asked by: phanimv | Member Since Jul-2006 | Asked on: Apr 20th, 2007

View all questions by phanimv   View all answers by phanimv

Showing Answers 1 - 4 of 4 Answers
rahul

Answered On : May 22nd, 2007

Yes, we can update the target table by using the session properties.
There are some options in the Session properties.

  
Login to rate this answer.
vivek1708

Answered On : Jul 30th, 2008

View all answers by vivek1708

using :Tu
Targetupdate override.

Yes  3 Users have rated as useful.
  
Login to rate this answer.

By using source qualifier transformation to update tha target table,through SQL overriding...

  
Login to rate this answer.
Amit Gaikwad

Answered On : Jul 26th, 2012

Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.