Hello, I am little bit confused in using RSA 3 transaction.
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
3. What is the exact use of RSA3 transaction. Plz explain.
Thanks
Ashwin,
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
--> yes, BI side data initially stores at PSA.
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
--> For FULL loads and Initialization with data transfer data pulled from Setup tables.
--> For Delta Loads data pulled from delta queue.
3. What is the exact use of RSA3 transaction. Plz explain.
--> To check data, for example after enhancing datasource with newfiels we can and debugg thourgh RSA3.
Srini
Hi,
1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.
Yes DataSource is a Structure and it won't store data, it will pick the data from base tables/Delta Queue
2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.
If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7
First Time you need to fill setup tables and then load Init in BW using setup tables. After that set V3 job an dthen load deltas in BW, it will pick the data from RSA7 (Delta Queue). If you want to delete an dload data again, then delete setup tables, delete Queues in SMQ1/LBWQ and then RSA7.
3. What is the exact use of RSA3 transaction. Plz explain.
This is the place to test your DataSource, whethere the data is extacting correctly or not?.
Thanks
Reddy
Add a comment