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

How to check whether set up tables are filled or not

Hi Gurus,

How to check whehter set up tables are filled or not?

Cheers,

Reddy.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 14, 2009 at 10:20 AM

    Just execute a full load in RSA3 and see if gets any records. If yes, the setup tables are filled.

    To be on the safe side, delete the existing setup tables and make sure that you fill them just before executing an Init. or full load into the BI system. Also make sure there are no transactions in the Source-system during the period starting from when the setup tables are filled and upto the time an init. has been loaded into the BI system

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Reddy.......

      And another point I want to make u clear............LBWQ is not the Delta Queue.............Delta queue is RSA7...............it comes into play in delta loading.......LBWQ is Extraction Queue.........While delta loading....if we use the Update mode Queued Delta........then any Changes will not directly get updated in the Delta queue.....For the Delta set up.........

      1) First u hav to run init with data transfer(After filling the set up table)

      2) After that any Changed ........will be recorded in the Extraction Queue(LBWQ)........

      3) After a certain number of records get accumulated in LBWQ........We hav to run V3 jobs to bring the data in the Delta queue(RSA7)...

      Check this.....

      Regards,

      Debjani.....

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 10:16 AM

    With the extractor checker (RSA3)

    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.