tailieunhanh - SAS Data Integration Studio 3.3- P48

SAS Data Integration Studio P48:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | 240 Index verifying transformation output 188 default metadata repository 95 default SAS application server 15 registering 57 selecting 96 Delimited External File wizard 72 denormalizing source data 40 deploying jobs for execution on remote host 68 for scheduling 65 desktop 13 dimension tables 195 See also slowly changing dimensions SCD adding SCD columns to 206 loading source data into 202 primary key for 207 tracking changes to values 196 dimensional data creating 41 dimensions 195 See also slowly changing dimensions SCD definition 195 disk space for intermediate files 184 E enterprise applications libraries for 63 enterprise model for data warehousing 40 error log location 94 example data warehouse 43 libraries for 61 server metadata for 56 executing jobs 7 Export Job to File wizard 29 exporting generated transformations 87 metadata 72 98 Expression Builder window 16 105 external file properties windows 26 external files 72 creating metadata objects for 72 HTTP or FTP access to 72 source designers for registering 126 updating metadata 106 viewing data in process flow 110 viewing data in tree view 110 viewing metadata 112 External Files wizard 31 extracting source data 40 F Fact Table Lookup transformation 198 fact tables 196 Fixed Width External File wizard 72 foreign keys 98 formats for transferring data 182 libraries for custom SAS formats 62 FTP access to external files 72 G generated code methods of customizing or replacing 223 replacing with user-written code 226 generated key for SCD Loader 209 generated transformations 24 75 87 adding to Process Library 228 checking in 86 creating 76 creating user-defined variables 78 documenting usage details 87 importing and exporting 87 in jobs 87 174 maintaining 75 SAS code for 78 saving 86 generating surrogate keys 201 Generic libraries 63 H Help 4 HTTP access to external files 72 I impact analysis 116 Import COBOL Copybook wizard 29 Import Cube wizard 29 importing generated transformations 87 metadata 72 98 metadata