Question:
We have an ODS1 to which we are loading the data from another ODS2. We wrote a start routine in this case. We are getting 100 records from ODS2 to ODS1. We modified the data and sent the results into ODS1 internal table. In the Internal table we supposed to have 150 records. But when we load the data and see in the ODS1, we could see only 100 number. Is there any reason behind it? Whether ODS1 does not take more than the input record numbers?
Your suggestion is highly appreciated.
Thanks,
Answer:
In the Internal table we supposed to have 150 records.
and why are you "supposed" to have 150 records when you're only sending 100???
if you wish to have more records in your ODS than you are sending, you either need to append records in the data_package table or you work with result tables in the update rules... otherwise your max no of records will be the no of records you are sending
Answer:
How can I use this result table and where do I have this table exactly? Could you plesae brief me little more details.
Answer:
you work with result tables in the update rules
I'd say have a look at the update rules