Pentaho data integration 4 cookbook :: over 70 recipes to solve ETL problems using Pentaho Kettle /
This book has step-by-step instructions to solve data manipulation problems using PDI in the form of recipes. It has plenty of well-organized tips, screenshots, tables, and examples to aid quick and easy understanding. If you are a software developer or anyone involved or interested in developing ET...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, U.K. :
Packt Pub.,
2011.
|
| Schriftenreihe: | Quick answers to common problems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | This book has step-by-step instructions to solve data manipulation problems using PDI in the form of recipes. It has plenty of well-organized tips, screenshots, tables, and examples to aid quick and easy understanding. If you are a software developer or anyone involved or interested in developing ETL solutions, or in general, doing any kind of data manipulation, this book is for you. It does not cover PDI basics, SQL basics, or database concepts. You are expected to have a basic understanding of the PDI tool, SQL language, and databases. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (1 electronic source (iii, 332 pages)) : illustrations |
| ISBN: | 9781849515252 1849515255 1849515247 9781849515245 1283349442 9781283349444 9786613349446 6613349445 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn758977883 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 111028s2011 enka o 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d N$T |d E7B |d OCLCQ |d DEBSZ |d OCLCQ |d NLGGC |d YDXCP |d IDEBK |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d COO |d OCLCQ |d LOA |d JBG |d AGLDB |d ICA |d CNNOR |d MOR |d PIFAG |d OCLCQ |d U3W |d D6H |d STF |d WRM |d VTS |d NLE |d VT2 |d OCLCQ |d UKMGB |d A6Q |d UKAHL |d HS0 |d VLY |d AJS |d NRAMU |d CRU |d INT |d OCLCQ |d OCLCO |d INARC |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBB747680 |2 bnb | ||
| 016 | 7 | |a 018014749 |2 Uk | |
| 019 | |a 747411344 |a 767809342 |a 816874537 |a 823130621 |a 961555850 |a 962625730 |a 966212208 |a 988410860 |a 991924875 |a 1037709308 |a 1038616942 |a 1045440918 |a 1055384496 |a 1081217582 |a 1083602305 |a 1103271782 |a 1129348275 |a 1153037172 |a 1162236970 |a 1241802828 |a 1290106802 |a 1300507373 | ||
| 020 | |a 9781849515252 |q (electronic bk.) | ||
| 020 | |a 1849515255 |q (electronic bk.) | ||
| 020 | |a 1849515247 | ||
| 020 | |a 9781849515245 | ||
| 020 | |a 1283349442 | ||
| 020 | |a 9781283349444 | ||
| 020 | |a 9786613349446 | ||
| 020 | |a 6613349445 | ||
| 020 | |z 9781849515245 | ||
| 035 | |a (OCoLC)758977883 |z (OCoLC)747411344 |z (OCoLC)767809342 |z (OCoLC)816874537 |z (OCoLC)823130621 |z (OCoLC)961555850 |z (OCoLC)962625730 |z (OCoLC)966212208 |z (OCoLC)988410860 |z (OCoLC)991924875 |z (OCoLC)1037709308 |z (OCoLC)1038616942 |z (OCoLC)1045440918 |z (OCoLC)1055384496 |z (OCoLC)1081217582 |z (OCoLC)1083602305 |z (OCoLC)1103271782 |z (OCoLC)1129348275 |z (OCoLC)1153037172 |z (OCoLC)1162236970 |z (OCoLC)1241802828 |z (OCoLC)1290106802 |z (OCoLC)1300507373 | ||
| 037 | |a 9781849515252 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a QA76.9.D338 |b S47 2011eb | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 7 | |a 005.73 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Sergio Pulvirenti, Adrián. | |
| 245 | 1 | 0 | |a Pentaho data integration 4 cookbook : |b over 70 recipes to solve ETL problems using Pentaho Kettle / |c Adrián Sergio Pulvirenti, María Carina Roldán. |
| 260 | |a Birmingham, U.K. : |b Packt Pub., |c 2011. | ||
| 300 | |a 1 online resource (1 electronic source (iii, 332 pages)) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Quick answers to common problems | |
| 500 | |a Includes index. | ||
| 520 | |a This book has step-by-step instructions to solve data manipulation problems using PDI in the form of recipes. It has plenty of well-organized tips, screenshots, tables, and examples to aid quick and easy understanding. If you are a software developer or anyone involved or interested in developing ETL solutions, or in general, doing any kind of data manipulation, this book is for you. It does not cover PDI basics, SQL basics, or database concepts. You are expected to have a basic understanding of the PDI tool, SQL language, and databases. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Working with Databases; Introduction; Connecting to a database; Getting data from a database; Getting data from a database by providing parameters; Getting data from a database by running a query built at runtime; Inserting or updating rows in a table; Inserting new rows where a simple primary key has to be generated; Inserting new rows where the primary key has to be generated based on stored values; Deleting data from a table | |
| 505 | 8 | |a Creating or altering a database table from PDI (design time)Creating or altering a database table from PDI (runtime); Inserting, deleting, or updating a table depending on a field; Changing the database connection at runtime; Loading a parent-child table; Chapter 2:Reading and Writing Files; Introduction; Reading a simple file; Reading several files at the same time; Reading unstructured files; Reading files having one field by row; Reading files with some fields occupying two or more rows; Writing a simple file; Writing an unstructured file | |
| 505 | 8 | |a Providing the name of a file (for reading or writing) dynamicallyUsing the name of a file (or part of it) as a field; Reading an Excel file; Getting the value of specific cells in an Excel file; Writing an Excel file with several sheets; Writing an Excel file with a dynamic number of sheets; Chapter 3:Manipulating XML Structures; Introduction; Reading simple XML files; Specifying fields by using XPath notation; Validating well-formed XML files; Validating an XML file against DTD definitions; Validating an XML file against an XSD schema; Generating a simple XML document | |
| 505 | 8 | |a Generating complex XML structuresGenerating an HTML page using XML and XSL transformations; Chapter 4:File Management; Introduction; Copying or moving one or more files; Deleting one or more files; Getting files from a remote server; Putting files on a remote server; Copying or moving a custom list of files; Deleting a custom list of files; Comparing files and folders; Working with ZIP files; Chapter 5:Looking for Data; Introduction; Looking for values in a database table; Looking for values in a database (with complex conditions or multiple tables involved) | |
| 505 | 8 | |a Looking for values in a database with extreme flexibilityLooking for values in a variety of sources; Looking values by proximity; Looking for values consuming a web service; Looking for values over an intranet; Chapter 6:Understanding Data Flows; Introduction; Splitting a stream into two or more streams based on a condition; Merging rows of two streams with the same or different structures; Comparing two streams and generating differences; Generating all possible pairs formed from two datasets; Joining two or more streams based on given conditions; Interspersing new rows between existent rows | |
| 546 | |a English. | ||
| 650 | 0 | |a Data integration (Computer science) |0 http://id.loc.gov/authorities/subjects/sh2010014388 | |
| 650 | 0 | |a Database management |x Computer programs. |0 http://id.loc.gov/authorities/subjects/sh85035849 | |
| 650 | 0 | |a Open source software. |0 http://id.loc.gov/authorities/subjects/sh99003437 | |
| 650 | 2 | |a Database Management Systems |0 https://id.nlm.nih.gov/mesh/D003628 | |
| 650 | 6 | |a Intégration de données (Informatique) | |
| 650 | 6 | |a Bases de données |x Gestion |x Logiciels. | |
| 650 | 6 | |a Logiciels libres. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Data integration (Computer science) |2 fast | |
| 650 | 7 | |a Database management |x Computer programs |2 fast | |
| 650 | 7 | |a Open source software |2 fast | |
| 700 | 1 | |a Roldán, María Carina. | |
| 758 | |i has work: |a Pentaho data integration 4 cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3FyDCrjVDG77rQjJmBVmd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | |z 1849515247 | |
| 830 | 0 | |a Quick answers to common problems. |0 http://id.loc.gov/authorities/names/no2015091434 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=375323 |3 Volltext |
| 938 | |a Internet Archive |b INAR |n pentahodatainteg0000serg | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26943787 | ||
| 938 | |a ebrary |b EBRY |n ebr10482256 | ||
| 938 | |a EBSCOhost |b EBSC |n 375323 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 334944 | ||
| 938 | |a YBP Library Services |b YANK |n 6978698 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn758977883 |
|---|---|
| _version_ | 1816881774387527681 |
| adam_text | |
| any_adam_object | |
| author | Sergio Pulvirenti, Adrián |
| author2 | Roldán, María Carina |
| author2_role | |
| author2_variant | m c r mc mcr |
| author_facet | Sergio Pulvirenti, Adrián Roldán, María Carina |
| author_role | |
| author_sort | Sergio Pulvirenti, Adrián |
| author_variant | p a s pa pas |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D338 S47 2011eb |
| callnumber-search | QA76.9.D338 S47 2011eb |
| callnumber-sort | QA 276.9 D338 S47 42011EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Working with Databases; Introduction; Connecting to a database; Getting data from a database; Getting data from a database by providing parameters; Getting data from a database by running a query built at runtime; Inserting or updating rows in a table; Inserting new rows where a simple primary key has to be generated; Inserting new rows where the primary key has to be generated based on stored values; Deleting data from a table Creating or altering a database table from PDI (design time)Creating or altering a database table from PDI (runtime); Inserting, deleting, or updating a table depending on a field; Changing the database connection at runtime; Loading a parent-child table; Chapter 2:Reading and Writing Files; Introduction; Reading a simple file; Reading several files at the same time; Reading unstructured files; Reading files having one field by row; Reading files with some fields occupying two or more rows; Writing a simple file; Writing an unstructured file Providing the name of a file (for reading or writing) dynamicallyUsing the name of a file (or part of it) as a field; Reading an Excel file; Getting the value of specific cells in an Excel file; Writing an Excel file with several sheets; Writing an Excel file with a dynamic number of sheets; Chapter 3:Manipulating XML Structures; Introduction; Reading simple XML files; Specifying fields by using XPath notation; Validating well-formed XML files; Validating an XML file against DTD definitions; Validating an XML file against an XSD schema; Generating a simple XML document Generating complex XML structuresGenerating an HTML page using XML and XSL transformations; Chapter 4:File Management; Introduction; Copying or moving one or more files; Deleting one or more files; Getting files from a remote server; Putting files on a remote server; Copying or moving a custom list of files; Deleting a custom list of files; Comparing files and folders; Working with ZIP files; Chapter 5:Looking for Data; Introduction; Looking for values in a database table; Looking for values in a database (with complex conditions or multiple tables involved) Looking for values in a database with extreme flexibilityLooking for values in a variety of sources; Looking values by proximity; Looking for values consuming a web service; Looking for values over an intranet; Chapter 6:Understanding Data Flows; Introduction; Splitting a stream into two or more streams based on a condition; Merging rows of two streams with the same or different structures; Comparing two streams and generating differences; Generating all possible pairs formed from two datasets; Joining two or more streams based on given conditions; Interspersing new rows between existent rows |
| ctrlnum | (OCoLC)758977883 |
| dewey-full | 005.73 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.73 |
| dewey-search | 005.73 |
| dewey-sort | 15.73 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07403cam a2200793 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn758977883</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">111028s2011 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">N$T</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">NLGGC</subfield><subfield code="d">YDXCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">LOA</subfield><subfield code="d">JBG</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">CNNOR</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">U3W</subfield><subfield code="d">D6H</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">VTS</subfield><subfield code="d">NLE</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">A6Q</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">VLY</subfield><subfield code="d">AJS</subfield><subfield code="d">NRAMU</subfield><subfield code="d">CRU</subfield><subfield code="d">INT</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">INARC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB747680</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018014749</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">747411344</subfield><subfield code="a">767809342</subfield><subfield code="a">816874537</subfield><subfield code="a">823130621</subfield><subfield code="a">961555850</subfield><subfield code="a">962625730</subfield><subfield code="a">966212208</subfield><subfield code="a">988410860</subfield><subfield code="a">991924875</subfield><subfield code="a">1037709308</subfield><subfield code="a">1038616942</subfield><subfield code="a">1045440918</subfield><subfield code="a">1055384496</subfield><subfield code="a">1081217582</subfield><subfield code="a">1083602305</subfield><subfield code="a">1103271782</subfield><subfield code="a">1129348275</subfield><subfield code="a">1153037172</subfield><subfield code="a">1162236970</subfield><subfield code="a">1241802828</subfield><subfield code="a">1290106802</subfield><subfield code="a">1300507373</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849515252</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849515255</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849515247</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849515245</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1283349442</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781283349444</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9786613349446</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">6613349445</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849515245</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)758977883</subfield><subfield code="z">(OCoLC)747411344</subfield><subfield code="z">(OCoLC)767809342</subfield><subfield code="z">(OCoLC)816874537</subfield><subfield code="z">(OCoLC)823130621</subfield><subfield code="z">(OCoLC)961555850</subfield><subfield code="z">(OCoLC)962625730</subfield><subfield code="z">(OCoLC)966212208</subfield><subfield code="z">(OCoLC)988410860</subfield><subfield code="z">(OCoLC)991924875</subfield><subfield code="z">(OCoLC)1037709308</subfield><subfield code="z">(OCoLC)1038616942</subfield><subfield code="z">(OCoLC)1045440918</subfield><subfield code="z">(OCoLC)1055384496</subfield><subfield code="z">(OCoLC)1081217582</subfield><subfield code="z">(OCoLC)1083602305</subfield><subfield code="z">(OCoLC)1103271782</subfield><subfield code="z">(OCoLC)1129348275</subfield><subfield code="z">(OCoLC)1153037172</subfield><subfield code="z">(OCoLC)1162236970</subfield><subfield code="z">(OCoLC)1241802828</subfield><subfield code="z">(OCoLC)1290106802</subfield><subfield code="z">(OCoLC)1300507373</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781849515252</subfield><subfield code="b">Packt Publishing Pvt. Ltd</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D338</subfield><subfield code="b">S47 2011eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.73</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Sergio Pulvirenti, Adrián.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Pentaho data integration 4 cookbook :</subfield><subfield code="b">over 70 recipes to solve ETL problems using Pentaho Kettle /</subfield><subfield code="c">Adrián Sergio Pulvirenti, María Carina Roldán.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, U.K. :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2011.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 electronic source (iii, 332 pages)) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Quick answers to common problems</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">This book has step-by-step instructions to solve data manipulation problems using PDI in the form of recipes. It has plenty of well-organized tips, screenshots, tables, and examples to aid quick and easy understanding. If you are a software developer or anyone involved or interested in developing ETL solutions, or in general, doing any kind of data manipulation, this book is for you. It does not cover PDI basics, SQL basics, or database concepts. You are expected to have a basic understanding of the PDI tool, SQL language, and databases.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Working with Databases; Introduction; Connecting to a database; Getting data from a database; Getting data from a database by providing parameters; Getting data from a database by running a query built at runtime; Inserting or updating rows in a table; Inserting new rows where a simple primary key has to be generated; Inserting new rows where the primary key has to be generated based on stored values; Deleting data from a table</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Creating or altering a database table from PDI (design time)Creating or altering a database table from PDI (runtime); Inserting, deleting, or updating a table depending on a field; Changing the database connection at runtime; Loading a parent-child table; Chapter 2:Reading and Writing Files; Introduction; Reading a simple file; Reading several files at the same time; Reading unstructured files; Reading files having one field by row; Reading files with some fields occupying two or more rows; Writing a simple file; Writing an unstructured file</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Providing the name of a file (for reading or writing) dynamicallyUsing the name of a file (or part of it) as a field; Reading an Excel file; Getting the value of specific cells in an Excel file; Writing an Excel file with several sheets; Writing an Excel file with a dynamic number of sheets; Chapter 3:Manipulating XML Structures; Introduction; Reading simple XML files; Specifying fields by using XPath notation; Validating well-formed XML files; Validating an XML file against DTD definitions; Validating an XML file against an XSD schema; Generating a simple XML document</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Generating complex XML structuresGenerating an HTML page using XML and XSL transformations; Chapter 4:File Management; Introduction; Copying or moving one or more files; Deleting one or more files; Getting files from a remote server; Putting files on a remote server; Copying or moving a custom list of files; Deleting a custom list of files; Comparing files and folders; Working with ZIP files; Chapter 5:Looking for Data; Introduction; Looking for values in a database table; Looking for values in a database (with complex conditions or multiple tables involved)</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Looking for values in a database with extreme flexibilityLooking for values in a variety of sources; Looking values by proximity; Looking for values consuming a web service; Looking for values over an intranet; Chapter 6:Understanding Data Flows; Introduction; Splitting a stream into two or more streams based on a condition; Merging rows of two streams with the same or different structures; Comparing two streams and generating differences; Generating all possible pairs formed from two datasets; Joining two or more streams based on given conditions; Interspersing new rows between existent rows</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Data integration (Computer science)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2010014388</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield><subfield code="x">Computer programs.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035849</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Open source software.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh99003437</subfield></datafield><datafield tag="650" ind1=" " ind2="2"><subfield code="a">Database Management Systems</subfield><subfield code="0">https://id.nlm.nih.gov/mesh/D003628</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Intégration de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Logiciels libres.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data integration (Computer science)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="x">Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Open source software</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Roldán, María Carina.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Pentaho data integration 4 cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PD3FyDCrjVDG77rQjJmBVmd</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="z">1849515247</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Quick answers to common problems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015091434</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=375323</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Internet Archive</subfield><subfield code="b">INAR</subfield><subfield code="n">pentahodatainteg0000serg</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26943787</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10482256</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">375323</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">334944</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">6978698</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn758977883 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:18:04Z |
| institution | BVB |
| isbn | 9781849515252 1849515255 1849515247 9781849515245 1283349442 9781283349444 9786613349446 6613349445 |
| language | English |
| oclc_num | 758977883 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (1 electronic source (iii, 332 pages)) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Packt Pub., |
| record_format | marc |
| series | Quick answers to common problems. |
| series2 | Quick answers to common problems |
| spelling | Sergio Pulvirenti, Adrián. Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / Adrián Sergio Pulvirenti, María Carina Roldán. Birmingham, U.K. : Packt Pub., 2011. 1 online resource (1 electronic source (iii, 332 pages)) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Quick answers to common problems Includes index. This book has step-by-step instructions to solve data manipulation problems using PDI in the form of recipes. It has plenty of well-organized tips, screenshots, tables, and examples to aid quick and easy understanding. If you are a software developer or anyone involved or interested in developing ETL solutions, or in general, doing any kind of data manipulation, this book is for you. It does not cover PDI basics, SQL basics, or database concepts. You are expected to have a basic understanding of the PDI tool, SQL language, and databases. Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Working with Databases; Introduction; Connecting to a database; Getting data from a database; Getting data from a database by providing parameters; Getting data from a database by running a query built at runtime; Inserting or updating rows in a table; Inserting new rows where a simple primary key has to be generated; Inserting new rows where the primary key has to be generated based on stored values; Deleting data from a table Creating or altering a database table from PDI (design time)Creating or altering a database table from PDI (runtime); Inserting, deleting, or updating a table depending on a field; Changing the database connection at runtime; Loading a parent-child table; Chapter 2:Reading and Writing Files; Introduction; Reading a simple file; Reading several files at the same time; Reading unstructured files; Reading files having one field by row; Reading files with some fields occupying two or more rows; Writing a simple file; Writing an unstructured file Providing the name of a file (for reading or writing) dynamicallyUsing the name of a file (or part of it) as a field; Reading an Excel file; Getting the value of specific cells in an Excel file; Writing an Excel file with several sheets; Writing an Excel file with a dynamic number of sheets; Chapter 3:Manipulating XML Structures; Introduction; Reading simple XML files; Specifying fields by using XPath notation; Validating well-formed XML files; Validating an XML file against DTD definitions; Validating an XML file against an XSD schema; Generating a simple XML document Generating complex XML structuresGenerating an HTML page using XML and XSL transformations; Chapter 4:File Management; Introduction; Copying or moving one or more files; Deleting one or more files; Getting files from a remote server; Putting files on a remote server; Copying or moving a custom list of files; Deleting a custom list of files; Comparing files and folders; Working with ZIP files; Chapter 5:Looking for Data; Introduction; Looking for values in a database table; Looking for values in a database (with complex conditions or multiple tables involved) Looking for values in a database with extreme flexibilityLooking for values in a variety of sources; Looking values by proximity; Looking for values consuming a web service; Looking for values over an intranet; Chapter 6:Understanding Data Flows; Introduction; Splitting a stream into two or more streams based on a condition; Merging rows of two streams with the same or different structures; Comparing two streams and generating differences; Generating all possible pairs formed from two datasets; Joining two or more streams based on given conditions; Interspersing new rows between existent rows English. Data integration (Computer science) http://id.loc.gov/authorities/subjects/sh2010014388 Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Intégration de données (Informatique) Bases de données Gestion Logiciels. Logiciels libres. COMPUTERS Data Processing. bisacsh Data integration (Computer science) fast Database management Computer programs fast Open source software fast Roldán, María Carina. has work: Pentaho data integration 4 cookbook (Text) https://id.oclc.org/worldcat/entity/E39PD3FyDCrjVDG77rQjJmBVmd https://id.oclc.org/worldcat/ontology/hasWork 1849515247 Quick answers to common problems. http://id.loc.gov/authorities/names/no2015091434 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=375323 Volltext |
| spellingShingle | Sergio Pulvirenti, Adrián Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / Quick answers to common problems. Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Working with Databases; Introduction; Connecting to a database; Getting data from a database; Getting data from a database by providing parameters; Getting data from a database by running a query built at runtime; Inserting or updating rows in a table; Inserting new rows where a simple primary key has to be generated; Inserting new rows where the primary key has to be generated based on stored values; Deleting data from a table Creating or altering a database table from PDI (design time)Creating or altering a database table from PDI (runtime); Inserting, deleting, or updating a table depending on a field; Changing the database connection at runtime; Loading a parent-child table; Chapter 2:Reading and Writing Files; Introduction; Reading a simple file; Reading several files at the same time; Reading unstructured files; Reading files having one field by row; Reading files with some fields occupying two or more rows; Writing a simple file; Writing an unstructured file Providing the name of a file (for reading or writing) dynamicallyUsing the name of a file (or part of it) as a field; Reading an Excel file; Getting the value of specific cells in an Excel file; Writing an Excel file with several sheets; Writing an Excel file with a dynamic number of sheets; Chapter 3:Manipulating XML Structures; Introduction; Reading simple XML files; Specifying fields by using XPath notation; Validating well-formed XML files; Validating an XML file against DTD definitions; Validating an XML file against an XSD schema; Generating a simple XML document Generating complex XML structuresGenerating an HTML page using XML and XSL transformations; Chapter 4:File Management; Introduction; Copying or moving one or more files; Deleting one or more files; Getting files from a remote server; Putting files on a remote server; Copying or moving a custom list of files; Deleting a custom list of files; Comparing files and folders; Working with ZIP files; Chapter 5:Looking for Data; Introduction; Looking for values in a database table; Looking for values in a database (with complex conditions or multiple tables involved) Looking for values in a database with extreme flexibilityLooking for values in a variety of sources; Looking values by proximity; Looking for values consuming a web service; Looking for values over an intranet; Chapter 6:Understanding Data Flows; Introduction; Splitting a stream into two or more streams based on a condition; Merging rows of two streams with the same or different structures; Comparing two streams and generating differences; Generating all possible pairs formed from two datasets; Joining two or more streams based on given conditions; Interspersing new rows between existent rows Data integration (Computer science) http://id.loc.gov/authorities/subjects/sh2010014388 Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Intégration de données (Informatique) Bases de données Gestion Logiciels. Logiciels libres. COMPUTERS Data Processing. bisacsh Data integration (Computer science) fast Database management Computer programs fast Open source software fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh2010014388 http://id.loc.gov/authorities/subjects/sh85035849 http://id.loc.gov/authorities/subjects/sh99003437 https://id.nlm.nih.gov/mesh/D003628 |
| title | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / |
| title_auth | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / |
| title_exact_search | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / |
| title_full | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / Adrián Sergio Pulvirenti, María Carina Roldán. |
| title_fullStr | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / Adrián Sergio Pulvirenti, María Carina Roldán. |
| title_full_unstemmed | Pentaho data integration 4 cookbook : over 70 recipes to solve ETL problems using Pentaho Kettle / Adrián Sergio Pulvirenti, María Carina Roldán. |
| title_short | Pentaho data integration 4 cookbook : |
| title_sort | pentaho data integration 4 cookbook over 70 recipes to solve etl problems using pentaho kettle |
| title_sub | over 70 recipes to solve ETL problems using Pentaho Kettle / |
| topic | Data integration (Computer science) http://id.loc.gov/authorities/subjects/sh2010014388 Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Intégration de données (Informatique) Bases de données Gestion Logiciels. Logiciels libres. COMPUTERS Data Processing. bisacsh Data integration (Computer science) fast Database management Computer programs fast Open source software fast |
| topic_facet | Data integration (Computer science) Database management Computer programs. Open source software. Database Management Systems Intégration de données (Informatique) Bases de données Gestion Logiciels. Logiciels libres. COMPUTERS Data Processing. Database management Computer programs Open source software |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=375323 |
| work_keys_str_mv | AT sergiopulvirentiadrian pentahodataintegration4cookbookover70recipestosolveetlproblemsusingpentahokettle AT roldanmariacarina pentahodataintegration4cookbookover70recipestosolveetlproblemsusingpentahokettle |