hi That is really helpful comments. The one confirmation most useful for me is "If you append rows to a promoted table using the DATA STEP append option, the new rows are automatically promoted" I am working on one such ETL scenario, i am new to SAS studio. Can I contact for help related to issues i am facing. Arundhati