Skip to Content
author's profile photo Former Member
Former Member

Data Services Refresh Problem

Hello Guys,

I am New to Data Services SP3 ..Now we need to implement Validation on Explorer(Polestar) .....As we have One table in Database as Source and created template table in designer and extracted data from source table, After then Created Acclerator Index and implemented on Polestar..

Now i am facing issue on refersh....In database we did modifications source table then i checked Designer source table it was updated but not target table( Template Table in my case) ...Pls suggest me what to do??? I tried with Data services management console it was loading twice and row count was doubled.

And, How to do Incremental Refresh on Daily Basis in data services (Daily Schedule Batch Job on daily Basis but on incremental refresh)as You Know i am very new to this tool...

Thanks in Advance

Sudheer Bandaru.....

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 01, 2012 at 05:10 AM

    Hi Sudheer,

    You can refresh the job from Management Console. Login to the Administrator > Batch Jobs> Schedules and give daily and multiple times a day.

    Is that some thing you look for?

    Also, regarding row count doubling, you may have to truncate the target table before loading. Double click the target table, in the options check delete data on load.

    Thanks,
    Arun

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.