Hi Sushil; Data builder is a good tool for doing proof of concept work, but not the right tool for developing production processes. Specifically, there are two main drawbacks to using the VA data builder. First, data builder it is not a full functioning ETL tool and is not nearly as powerful as DI. Second, using the data builder tool produces a query that must be executed every time you want to load this table into memory. This produces both load on your data warehouse and needless network traffic. It is possible that you may wish to swap datasets in and out of memory as necessary and in this case you don't want to have to rebuild the table every time you load it if the data in it hasn't changed (like for a month-end snapshot table). For this reason I recommend doing all data preparation in DI, culminating with the creation of a single "Analytical Base Table" capable of supporting your analysis task. This table would be in a "VA Ready State", would be registered in metadata and can be lifted directly into memory without any additional processing. In this scenario you would use the "Administrator Load" approach outlined on page 14 of the SAS Analytics Server Administration Guide. I hope this helps. Shaun. PS. DI jobs can't be created in SAS VA data builder.
... View more