{"id":5036,"date":"2014-05-15T16:36:12","date_gmt":"2014-05-15T20:36:12","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=5036"},"modified":"2017-11-07T09:56:55","modified_gmt":"2017-11-07T14:56:55","slug":"creating-multibyte-test-data","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/","title":{"rendered":"Creating Multi-byte Test Data"},"content":{"rendered":"

RowGen produces test values in target database tables, flat files, and custom reports through either random data generation (based on the defined data type) or random selection (using different random pull methods) from data in “set files.”<\/p>\n

This example shows how IRI RowGen<\/a> can be used to provide test data or pseudonymous insertions in a Korean name column.<\/p>\n

Remember that set files contain\u00a0single or multiple (tab-delimited)\u00a0fields\u00a0that can pre-exist, or as shown here, be created automatically from existing database columns. The set file below was built\u00a0by the set file creation wizard in the RowGen GUI<\/a> in IRI Workbench<\/a>, built on Eclipse\u2122.<\/p>\n

\n
 # Generated with IRI Workbench - Create Set File from Column(s)\r\n # File Name: C:\/IRI\/RowGen31\/sets\/20140602\/MB_NAME.set\r\n # Author: Administrator\r\n # Created: 2014-06-03 11:06:12\r\n \uc774\ubc94\ud76c\r\n \uc774\ubc94\uc900\r\n \uc774\uc900\ud0dc\r\n \ucd5c\uc9c4\ud765\r\n \uc774\uc548\r\n \uae40\uba85\ud6c8\r\n \uc724\uc9c0\ud61c\r\n \uae40\ub098\uc5f0\r\n \uae40\ub3d9\uaddc\r\n \uc784\ubbf8\uacbd\r\n \uc720\ud604\uc8fc\r\n \uc720\uc5f0\uc8fc\r\n \uc784\ub3d9\uaddc\r\n \uc624\ud604\uc8fc\r\n \uc784\uc218\ube48\r\n \uc784\uc218\uc5f0\r\n \uae40\ub300\ud5cc\r\n \ub098\uc724\uc815\r\n \uae40\ub098\uc6d0\r\n \uc774\uc601\uac78\r\n \uae40\uc18c\ub9bc\r\n \uc774\ud604\uc900\r\n \ubc15\uc6a9\uc900\r\n \ubc30\uc740\uc8fc\r\n \ubc15\uc9c0\ud61c\r\n \ubc15\uc9c0\ubbfc\r\n \uc815\uc6a9\uc8fc\r\n \uc6b0\uacbd\uc560\r\n \uc815\uc218\ube48\r\n \uc815\uc9c0\uc6b0\r\n \uae40\ub450\uc644\r\n \uc804\uc120\ud76c\r\n \uae40\uc720\ubbfc\r\n \uae40\uc218\uc815<\/pre>\n
…\u00a0this file continues for millions of rows …<\/p><\/blockquote>\n
Given the set above, and this simple\u00a0RowGen control language (.rcl) job specification file,<\/p>\n
\n
\u00a0\/INFILE = placeholder.in   # not used \r\n \/PROCESS = random \r\n \/REPORT \r\n \/OUTFILE = out\r\n \/FIELD = (K_Name,pos=1, SET = MB_NAME.set)\r\n \/OUTCOLLECT = 10      # show only 10 names<\/pre>\n<\/blockquote>\n
the resulting test data generated is merely a random pull of 10 records from the input set, shown here:<\/p>\n
\n
\uc774\uc11c\uc900\u00a0<\/span>
\ubc15\uc9c0\ud61c\u00a0<\/span>
\uae40\uc18c\ub9bc\u00a0<\/span>
\ubc15\uc6a9\uc900\u00a0<\/span>
\uc784\ub3d9\uaddc\u00a0<\/span>
\ubc30\uc740\uc8fc\u00a0<\/span>
\uc9c4\uc740\ud61c\u00a0<\/span>
\uc774\ud604\uc900\u00a0<\/span>
\uc804\uc120\ud76c\u00a0<\/span>
\uc774\ubc94\ud76c\r\n<\/span><\/pre>\n<\/blockquote>\n
Additional columns could be generated or selected for the output if desired. For more information on how IRI software\u00a0creates\u00a0and uses single and multi-byte lookup sets in data masking and test data provisioning scenarios, contact support@iri.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
RowGen produces test values in target database tables, flat files, and custom reports through either random data generation (based on the defined data type) or random selection (using different random pull methods) from data in “set files.” This example shows how IRI RowGen can be used to provide test data or pseudonymous insertions in a<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":8,"featured_media":5056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[29],"tags":[432,431,430,433,434,190,49],"class_list":["post-5036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-test-data","tag-generate-test-data","tag-korean-test-data","tag-multi-byte-test-data","tag-random-data-generation","tag-random-selection-for-test-data","tag-realistic-test-data","tag-rowgen"],"acf":[],"yoast_head":"\nCreating Multi-byte Test Data - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Multi-byte Test Data\" \/>\n<meta property=\"og:description\" content=\"RowGen produces test values in target database tables, flat files, and custom reports through either random data generation (based on the defined data type) or random selection (using different random pull methods) from data in “set files.” This example shows how IRI RowGen can be used to provide test data or pseudonymous insertions in aRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-15T20:36:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T14:56:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"299\" \/>\n\t<meta property=\"og:image:height\" content=\"254\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Paul Friedland\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Friedland\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\"},\"author\":{\"name\":\"Paul Friedland\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/1127ccf5631e8b00cb23974bd1882ea9\"},\"headline\":\"Creating Multi-byte Test Data\",\"datePublished\":\"2014-05-15T20:36:12+00:00\",\"dateModified\":\"2017-11-07T14:56:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\"},\"wordCount\":186,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg\",\"keywords\":[\"generate test data\",\"Korean test data\",\"multi-byte test data\",\"random data generation\",\"random selection for test data\",\"realistic test data\",\"RowGen\"],\"articleSection\":[\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\",\"url\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\",\"name\":\"Creating Multi-byte Test Data - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg\",\"datePublished\":\"2014-05-15T20:36:12+00:00\",\"dateModified\":\"2017-11-07T14:56:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg\",\"width\":299,\"height\":254},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Multi-byte Test Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/1127ccf5631e8b00cb23974bd1882ea9\",\"name\":\"Paul Friedland\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5d48eea2eec2c3bcb24db5080f6ab3c5?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5d48eea2eec2c3bcb24db5080f6ab3c5?s=96&d=blank&r=g\",\"caption\":\"Paul Friedland\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/paulf\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating Multi-byte Test Data - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/","og_locale":"en_US","og_type":"article","og_title":"Creating Multi-byte Test Data","og_description":"RowGen produces test values in target database tables, flat files, and custom reports through either random data generation (based on the defined data type) or random selection (using different random pull methods) from data in “set files.” This example shows how IRI RowGen can be used to provide test data or pseudonymous insertions in aRead More","og_url":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/","og_site_name":"IRI","article_published_time":"2014-05-15T20:36:12+00:00","article_modified_time":"2017-11-07T14:56:55+00:00","og_image":[{"width":299,"height":254,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","type":"image\/jpeg"}],"author":"Paul Friedland","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Friedland","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/"},"author":{"name":"Paul Friedland","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/1127ccf5631e8b00cb23974bd1882ea9"},"headline":"Creating Multi-byte Test Data","datePublished":"2014-05-15T20:36:12+00:00","dateModified":"2017-11-07T14:56:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/"},"wordCount":186,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","keywords":["generate test data","Korean test data","multi-byte test data","random data generation","random selection for test data","realistic test data","RowGen"],"articleSection":["Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/","url":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/","name":"Creating Multi-byte Test Data - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","datePublished":"2014-05-15T20:36:12+00:00","dateModified":"2017-11-07T14:56:55+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","width":299,"height":254},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/test-data\/creating-multibyte-test-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating Multi-byte Test Data"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/1127ccf5631e8b00cb23974bd1882ea9","name":"Paul Friedland","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5d48eea2eec2c3bcb24db5080f6ab3c5?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d48eea2eec2c3bcb24db5080f6ab3c5?s=96&d=blank&r=g","caption":"Paul Friedland"},"url":"https:\/\/www.iri.com\/blog\/author\/paulf\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/06\/Korean-phone-number-test-data.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5036"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=5036"}],"version-history":[{"count":15,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5036\/revisions"}],"predecessor-version":[{"id":11222,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5036\/revisions\/11222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/5056"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=5036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=5036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=5036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}