| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNISALENTO991001645769707536 |
|
|
Titolo |
Ventilazione degli edifici : Metodi di calcolo per la determinazione delle portate d'aria negli edifici, comprese le infiltrazioni / Ente Nazionale Italiano di Unificazione |
|
|
|
|
|
|
|
Altri autori (Enti) |
|
Ente Nazionale Italiano di Unificazione.Commissione Tecnica UNIauthor |
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
2. |
Record Nr. |
UNINA9910964237503321 |
|
|
Autore |
Rad Reza |
|
|
Titolo |
Microsoft SQL Server 2012 integration services : an expert cookbook : over 80 expert recipes to design, create, and deploy SSIS packages / / Reza Rad, Pedro Perfeito ; [foreword by Phil Brammer] |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Olton, Birmingham [England], : Packt Pub., 2012 |
|
|
|
|
|
|
|
ISBN |
|
9786613653628 |
9781280676697 |
1280676698 |
9781849685252 |
1849685258 |
|
|
|
|
|
|
|
|
Edizione |
[1st ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (564 p.) |
|
|
|
|
|
|
Collana |
|
Quick answers to common problems |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Microsoft software |
Data integration (Computer science) |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with SQL Server Integration Services; Introduction; |
|
|
|
|
|
|
|
|
|
|
|
Import and Export Wizard: First experience with SSIS; Getting started with SSDT; Creating the first SSIS Package; Getting familiar with Data Flow Task; SSIS 2012 versus previous versions in Developer Experience; Chapter 2: Control Flow Tasks; Introduction; Executing T-SQL commands: Execute SQL Task; Handling file and folder operations: File System Task |
Sending and receiving files through FTP: FTP TaskExecuting other packages: Execute Package Task; Running external applications: Execute Process Task; Reading data from web methods: Web Service Task; Transforming, validating, and querying XML: XML Task; Profiling table statistics: Data Profiling Task; Batch insertion of data into a database: Bulk Insert Task; Querying system information: WMI Data Reader Task; Querying system events: WMI Event Watcher Task; Transferring SQL server objects: DBMS Tasks; Chapter 3: Data Flow Task Part 1-Extract and Load; Introduction |
Working with database connections in Data FlowWorking with flat files in Data Flow; Passing data between packages-Raw Source and Destination; Importing XML data with XML Source; Loading data into memory-Recordset Destination; Extracting and loading Excel data; Change Data Capture; Chapter 4: Data Flow Task Part 2-Transformations; Introduction; Derived Column: adding calculated columns; Audit Transformation: logging in Data Flow; Aggregate Transform: aggregating the data stream; Conditional Split: dividing the data stream based on conditions; Lookup Transform: performing the Upsert scenario |
OLE DB Command: executing SQL statements on each row in the data streamMerge and Union All transformations: combining input data rows; Merge Join Transform: performing different types of joins in data flow; Multicast: creating copies of the data stream; Working with BLOB fields: Export Column and Import Column transformations; Slowly Changing Dimensions (SCDs) in SSIS; Chapter 5: Data Flow Task Part 3-Advanced Transformation; Introduction; Pivot and Unpivot Transformations; Text Analysis with Term Lookup and Term Extraction transformations; DQS Cleansing Transformation-Cleansing Data |
Fuzzy Transformations-how SSIS understands fuzzy similaritiesChapter 6: Variables, Expressions, and Dynamism in SSIS; Introduction; Variables and data types; Using expressions in Control Flow; Using expressions in Data Flow; The Expression Task; Dynamic connection managers; Dynamic data transfer with different data structures; Chapter 7: Containers and Precedence Constraints; Introduction; Sequence Container: putting all tasks in an executable object; For Loop Container: looping through static enumerator till a condition is met |
Foreach Loop Container: looping through result set of a database query |
|
|
|
|
|
|
Sommario/riassunto |
|
Over 100 expert recipes to design, create, and deploy SSIS packages with this book and ebook |
|
|
|
|
|
|
|
| |