 Related Questions Answered by kiran on 2005-05-08 09:27:46: Power Mart is designed for: Low range of warehouses only for local repositories mainly desktop environment. Power mart is designed Latest Answer : Power Center is designed for:High-end WarehousesGlobal as well as local repositoriesPower Mart is designed for:Low-end WarehousesOnly for local repositories ... I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.RegRam Can anyone please explain why and where do we exactly use the lookup tranformations.thanks in advacnethanksnayana Read Answers (5) | Asked by : nayana In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference between Read Answers (2) | Asked by : srihari Latest Answer : Global shortcuts are across multiple repositories,Local shortcuts are across multiple folders in the same repository. ... Read Answers (1) | Asked by : Rohit Gupta Latest Answer : (sources)---------->Staging Area(Transformation)---->Target------>Interface-->ReportsData baseFlat filecobol fileXML file ... Read Answers (1) | Asked by : sainath What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain Latest Answer : Truncate table will be executed first.Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded) ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 
0