{"id":6763,"date":"2026-07-12T02:08:03","date_gmt":"2026-07-12T10:08:03","guid":{"rendered":"https:\/\/www.gudusoft.com\/db2-data-lineage\/"},"modified":"2026-07-12T02:08:03","modified_gmt":"2026-07-12T10:08:03","slug":"db2-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/db2-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"DB2 \ub370\uc774\ud130 \uacc4\ubcf4: IBM DB2 SQL\uc6a9 \uc5f4 \uc218\uc900 \uacc4\ubcf4"},"content":{"rendered":"<p><strong>DB2 \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \uc774\ub294 IBM DB2 SQL\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc744 \uc5f4 \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc785\ub2c8\ub2e4. \uc989, \uac01 \ubdf0, \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ud14c\uc774\ube14 \ubc0f \ubcf4\uace0\uc11c \ucd94\ucd9c\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc0ac\uc6a9\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uc870\uc778, \ud544\ud130, \ud45c\ud604\uc2dd \ubc0f MERGE \ubd84\uae30\ub97c \uac70\uce58\ub294\uc9c0 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <strong>Gudu SQLFlow<\/strong> \uc774 \ub3c4\uad6c\ub294 DB2 \uc804\uc6a9 \ud30c\uc11c\ub85c DB2 SQL\uc744 \ubd84\uc11d\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \ub9f5\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \uad6c\uc870\ud654\ub41c \uacc4\ubcf4 \ub370\uc774\ud130\ub294 JSON, CSV, PNG \ub610\ub294 REST API\ub97c \ud1b5\ud574 \uc81c\uacf5\ub418\uba70, \ub300\ud654\ud615\uc73c\ub85c \ub4dc\ub9b4\ub2e4\uc6b4 \uac00\ub2a5\ud55c \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>30\ucd08 \uc548\uc5d0 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> DB2 \ucffc\ub9ac\ub97c \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=db2-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc \uc628\ub77c\uc778 SQL \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>DB2 \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uba74 \uc5f4 \uc218\uc900 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">DB2 \ubd80\ub3d9\uc0b0\uc5d0\uc11c \ub2e4\ub978 \ubd80\ub3d9\uc0b0\ubcf4\ub2e4 \uacc4\ubcf4 \uc815\ubcf4\uac00 \ub354 \uc911\uc694\ud55c \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>DB2\ub294 \ud575\uc2ec \uc740\ud589 \uc7a5\ubd80, \ubcf4\ud5d8 \uacc4\uc57d \uad00\ub9ac, \ubcf4\ud5d8\uae08 \uccad\uad6c \ucc98\ub9ac, \uacb0\uc81c \ub4f1\uacfc \uac19\uc774 \ub204\uad6c\ub3c4 \uc190\ub308 \uc218 \uc5c6\ub294 \uc2dc\uc2a4\ud15c\uc744 \uc6b4\uc601\ud558\ub294 \ub370 \uc8fc\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc2dc\uc2a4\ud15c\ub4e4\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uacc4\ubcf4\ub97c \uc720\uc9c0\ud558\ub294 \uac83\uc774 \uc120\ud0dd \uc0ac\ud56d\uc774 \uc544\ub2c8\ub77c \ud544\uc218 \uc694\uac74\uc778 \uc138 \uac00\uc9c0 \uacf5\ud1b5\ub41c \ud2b9\uc9d5\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\ub098\uc774.<\/strong> \uc218\uc2ed \ub144 \ub3d9\uc548 \ub204\uc801\ub41c \ubdf0\ub4e4\uc774 \uacb9\uacb9\uc774 \uc313\uc774\uace0, \ubc30\uce58 SQL \uc791\uc5c5\uacfc SQL PL \ub8e8\ud2f4\uc774 \uc874\uc7ac\ud558\uae30 \ub54c\ubb38\uc5d0 \ub204\uad6c\ub3c4 \uc804\uccb4\uc801\uc778 \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \uba38\ub9bf\uc18d\uc5d0 \uc644\ubcbd\ud558\uac8c \ud30c\uc545\ud558\uace0 \uc788\uc9c0 \ubabb\ud558\uba70, \ucd5c\ucd08 \ucf54\ub4dc\ub97c \uc791\uc131\ud588\ub358 \uc0ac\ub78c\ub4e4\uc740 \uc774\ubbf8 \ud68c\uc0ac\ub97c \ub5a0\ub09c \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uaddc\uc81c.<\/strong> \uc740\ud589 \ubc0f \ubcf4\ud5d8 \uac10\uc0ac \ub2f4\ub2f9\uc790\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc138\ubd80\uc801\uc778 \uc9c8\ubb38\uc744 \ub358\uc9d1\ub2c8\ub2e4. \uc5b4\ub5a4 \uc18c\uc2a4 \ud544\ub4dc\uac00 \uc774 \uaddc\uc81c \ubcf4\uace0\uc11c \ub77c\uc778\uc73c\ub85c \uc720\uc785\ub418\ub294\uac00? BCBS 239\uc640 \uac19\uc740 \ud504\ub808\uc784\uc6cc\ud06c\ub294 2014\ub144\uc5d0 \ub204\uad70\uac00\uac00 \uadf8\ub9b0 \ub3c4\ud45c\uac00 \uc544\ub2c8\ub77c \ubb38\uc11c\ud654\ub418\uace0 \uc785\uc99d \uac00\ub2a5\ud55c \ub370\uc774\ud130 \ucd9c\ucc98\ub97c \uc694\uad6c\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc774\uc8fc \uc555\ub825.<\/strong> \ub9ce\uc740 DB2 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ud074\ub77c\uc6b0\ub4dc \uc6e8\uc5b4\ud558\uc6b0\uc2a4\ub85c\uc758 \uc774\uc804\uc744 \uacc4\ud68d\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc5b4\ub5a4 \uc694\uc18c\uac00 \ubb34\uc5c7\uc5d0 \uc758\uc874\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uac1d\uccb4\uac00 \ub354 \uc774\uc0c1 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ucf54\ub4dc\uc778\uc9c0, \uc5b4\ub5a4 \uac1d\uccb4\ub97c \ub0a8\uaca8\ub458 \uc218 \uc788\ub294\uc9c0\ub97c \uc54c\uc9c0 \ubabb\ud558\uba74 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc758 \ubc94\uc704, \uc21c\uc11c \ubc0f \uac80\uc99d\uc744 \uc81c\ub300\ub85c \uc218\ud589\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>Manual mapping does not survive contact with a real DB2 estate. Automated lineage from the SQL itself is the only approach that stays accurate as the code changes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\uac00 DB2 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub294 \ubc29\ubc95<\/h2>\n\n\n\n<p>SQLFlow\ub294 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c(GSP)<\/a>DB2\ub294 2000\ub144\ub300 \uc911\ubc18\ubd80\ud130 \uac1c\ubc1c\ub418\uc5b4 \uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 SQL \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c \uc0c1\uc6a9 SQL \ucef4\ud30c\uc77c\ub7ec \ud504\ub7f0\ud2b8\uc5d4\ub4dc \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">39\uac1c\uc758 \ubc29\uc5b8, \uac01 \ubc29\uc5b8\ub9c8\ub2e4 \uace0\uc720\ud55c \uad6c\ubb38 \ubd84\uc11d\uae30\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/a> \u2014 \ub2e8\uc21c\ud788 DB2 \ud2b9\uc720\uc758 \uad6c\ubb38\uc744 \ub367\ubd99\uc778 \uc77c\ubc18\uc801\uc778 ANSI \ubb38\ubc95\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uc774\ub294 DB2 SQL\uc774 \uc77c\ubc18\uc801\uc778 \ud30c\uc11c\uac00 \ucc98\ub9ac\ud558\uae30 \uc5b4\ub824\uc6b4 \uad6c\ubb38\uc73c\ub85c \uac00\ub4dd \ucc28 \uc788\uace0, \uad6c\ubb38 \ubd84\uc11d \uc2e4\ud328 \ud558\ub098\ud558\ub098\uac00 \ub370\uc774\ud130 \uacc4\ubcf4 \uadf8\ub798\ud504\uc5d0 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0a4\uae30 \ub54c\ubb38\uc5d0 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubd84\uc11d\uc740 \uc644\uc804\ud788 \uc815\uc801\uc785\ub2c8\ub2e4. SQLFlow\ub294 JDBC\ub97c \ud1b5\ud574 SQL \ud14d\uc2a4\ud2b8\uc640 \uc120\ud0dd\uc801\uc73c\ub85c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130\ub97c \uc785\ub825\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li>\ubd99\uc5ec\ub123\uc740 SQL \ub610\ub294 \uc5c5\ub85c\ub4dc\ub41c \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c - \ubc30\uce58 \uc791\uc5c5, DDL \ubcf4\uae30, \uc18c\uc2a4 \uc800\uc7a5\uc18c\uc5d0\uc11c \ub0b4\ubcf4\ub0b8 \ud30c\uc77c.<\/li>\n<li>JDBC\ub97c \ud1b5\ud574 \uc2e4\uc2dc\uac04 DB2 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ubbc0\ub85c \ubdf0 \uc815\uc758\uc640 \ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8\ub97c \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uc9c1\uc811 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uc804\uccb4 \ud658\uacbd \uc2a4\uce94: \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec \ud658\uacbd\uc5d0\uc11c 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \uc77c\uad04 \uc2a4\uce94\ud558\uace0, \uc99d\ubd84 \uc7ac\uc2a4\uce94 \ubc0f \uc601\uad6c\uc801\uc778 \ub370\uc774\ud130 \uacc4\ubcf4 \uc800\uc7a5\uc18c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 \uac01 \ucd9c\ub825 \uc5f4\uc5d0 \ub300\ud574 \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uc5b4\ub5a4 \ud568\uc218, \ud615\ubcc0\ud658, \uc11c\ube0c\ucffc\ub9ac, \uc870\uc778 \ubc0f \uc9d1\ud569 \uc5f0\uc0b0\uc790\ub97c \ud1b5\ud574 \ud574\ub2f9 \uc5f4\ub85c \uc804\ub2ec\ub418\ub294\uc9c0 \uc2dd\ubcc4\ud558\uace0, \uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd, \uc911\ucca9 \uc11c\ube0c\ucffc\ub9ac, \ubdf0 \ub4f1\uc744 \ud1b5\ud574 \ucc38\uc870\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4 *<\/code> \ud655\uc7a5.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DB2 \ud30c\uc11c\uac00 \uc774\ud574\ud558\ub294 \ub0b4\uc6a9<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>DB2 \uad6c\uc131<\/th><th>SQLFlow\ub294 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud560\uae4c\uc694?<\/th><\/tr><\/thead><tbody>\n<tr><td>\uc870\ud68c\uc218<\/td><td>\ubdf0 \uc815\uc758\ub294 \uacc4\ubcf4 \uadf8\ub798\ud504\ub85c \ud574\uc11d\ub418\ubbc0\ub85c \ubdf0\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub294 \ubdf0\uac00 5\ub2e8\uacc4 \uae4a\uc774\ub85c \uc313\uc5ec \uc788\ub354\ub77c\ub3c4 \uae30\ubcf8 \ud14c\uc774\ube14\uae4c\uc9c0 \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td><code>\ubcd1\ud569<\/code><\/td><td>\ub458 \ub2e4 <code>\ub9e4\uce6d \uc2dc... \uc5c5\ub370\uc774\ud2b8<\/code> \uadf8\ub9ac\uace0 <code>\uc77c\uce58\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0... \uc0bd\uc785<\/code> \uacc4\ud1b5\uc744 \ud3ec\ud568\ud558\uc5ec \uac00\uc9c0\ub4e4\uc744 \ubd84\uc11d\ud569\ub2c8\ub2e4. <code>\uc0ac\uc6a9<\/code> \ub300\uc0c1 \uc5f4\uc5d0 \ub300\ud55c \uc11c\ube0c\ucffc\ub9ac\uc785\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>\uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd<\/td><td>\uceec\ub7fc \ucc38\uc870\ub294 \ub2e4\uc74c\uc744 \ud1b5\ud574 \ud574\uacb0\ub429\ub2c8\ub2e4. <code>\uc640 \ud568\uaed8<\/code> \ube14\ub85d\uc5d0\ub294 \uc774\uc804 CTE\ub97c \ucc38\uc870\ud558\ub294 CTE\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>SQL PL \uad6c\uc131 \uc694\uc18c<\/td><td>\uad6c\ubb38 \ubd84\uc11d \uac00\ub2a5\ud55c SQL\ub85c \ucc98\ub9ac\ub428 \u2014 <code>\uc120\ud0dd\ud558\ub2e4<\/code>, <code>\ub07c\uc6cc \ub123\ub2e4<\/code>, <code>\uc5c5\ub370\uc774\ud2b8<\/code>, \uadf8\ub9ac\uace0 <code>\ubcd1\ud569<\/code> DB2 \ub8e8\ud2f4 \ub0b4\uc758 \uba85\ub839\ubb38\uc740 \uacc4\ubcf4 \uadf8\ub798\ud504\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc194\uc9c1\ud788 \ud55c \uac00\uc9c0 \uc8fc\uc758\ud560 \uc810\uc740 SQLFlow\uc758 \uc804\uc6a9 \ud504\ub85c\uc2dc\uc800 \ubb38\ubc95(\ub9e4\uac1c\ubcc0\uc218, \uc784\uc2dc \ud14c\uc774\ube14, \ub3d9\uc801 SQL\uc744 \ucd94\uc801\ud558\uace0 \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \ub80c\ub354\ub9c1\ud558\ub294 \ubb38\ubc95)\uc740 Oracle PL\/SQL \ubc0f SQL Server T-SQL\ub9cc \uc9c0\uc6d0\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. DB2 SQL PL\uc740 DB2 \uc804\uc6a9 \ud504\ub85c\uc2dc\uc800 \uc5d4\uc9c4\uc744 \ud1b5\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uc2e4\uc81c \ub370\uc774\ud130 \ud750\ub984\uc774 \uc774\ub8e8\uc5b4\uc9c0\ub294 \ubb38\uc7a5 \uc218\uc900\uc5d0\uc11c \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: DB2 MERGE\ub97c \ud1b5\ud55c \uceec\ub7fc \uc218\uc900 \uacc4\ubcf4<\/h2>\n\n\n\n<p>MERGE \uae30\ubc18 \uc5c5\uc11c\ud2b8\ub294 DB2 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 \ub85c\ub4dc\uc758 \ud575\uc2ec \uc791\uc5c5\uc774\uba70, \ud14c\uc774\ube14 \uc218\uc900 \uacc4\ubcf4\uac00 \ubd80\uc871\ud55c \ubd80\ubd84\uc774 \ubc14\ub85c \uc774 \uc5c5\uc11c\ud2b8 \uc791\uc5c5\uc5d0\uc11c \ub4dc\ub7ec\ub0a9\ub2c8\ub2e4. \uace0\uac1d \uc794\uc561 \uc694\uc57d\uc744 \uc720\uc9c0\ud558\ub294 \uc57c\uac04 \uc791\uc5c5\uc744 \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dw.customer_balance \ud14c\uc774\ube14\uc744 tgt \ud14c\uc774\ube14\ub85c \ubcd1\ud569\ud558\uace0, \ub2e4\uc74c \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ud589\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4: c.customer_id, c.branch_code, t.amount \ud569\uacc4, last_posted \uac12 \ud569\uacc4, \ub9c8\uc9c0\ub9c9 \uac8c\uc2dc \uc2dc\uac04(last_posted)\uc744 \uac01\uac01 core.transactions \ud14c\uc774\ube14\uc5d0\uc11c \uac00\uc838\uc640 core.customers \ud14c\uc774\ube14\uacfc \uc870\uc778\ud569\ub2c8\ub2e4. c.customer_id = t.customer_id \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ud589\uc744 t.status = &#039;POSTED&#039;\ub85c \uc124\uc815\ud558\uace0, c.customer_id\uc640 c.branch_code \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ud589\uc744 src \ud14c\uc774\ube14\uacfc \ud568\uaed8 \uc815\ub82c\ud569\ub2c8\ub2e4. \uc77c\uce58\ud558\ub294 \ud589\uc774 \uc788\uc73c\uba74 balance_amt \uac12\uc744 src.balance_amt\ub85c, last_posted \uac12\uc744 src.last_posted\ub85c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4. \uc77c\uce58\ud558\uc9c0 \uc54a\ub294 \ud589\uc774 \uc788\uc73c\uba74 (customer_id, branch_code, balance_amt, last_posted) \uac12\uc744 src.customer_id\uc640 \ud568\uaed8 \uc0bd\uc785\ud569\ub2c8\ub2e4. src.branch_code, src.balance_amt, src.last_posted);<\/code><\/pre>\n\n\n\n<p>SQLFlow\uc5d0\uc11c \uc774 \uba85\ub839\uc5d0 \ub300\ud55c \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \ub300\uc0c1 \uc5f4\ubcc4\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><code>dw.\uace0\uac1d_\uc794\uc561.\uc794\uc561_\uae08\uc561<\/code> ~\uc5d0 \uc758\ud574 \uacf5\uae09\ub429\ub2c8\ub2e4 <code>\ucf54\uc5b4 \ud2b8\ub79c\uc7ad\uc158 \uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569()<\/code> \u2014 UPDATE \ubd84\uae30\uc640 INSERT \ubd84\uae30 \ubaa8\ub450\ub97c \ud1b5\ud574.<\/li>\n<li><code>dw.customer_balance.last_posted<\/code> ~\uc5d0 \uc758\ud574 \uacf5\uae09\ub429\ub2c8\ub2e4 <code>\ucf54\uc5b4 \ud2b8\ub79c\uc7ad\uc158.\uac8c\uc2dc\ub41c_ts<\/code> ~\uc744 \ud1b5\ud574 <code>MAX()<\/code>.<\/li>\n<li><code>\ube0c\ub79c\uce58 \ucf54\ub4dc<\/code> \ubc14\ub85c \uac70\uae30\uc11c \uac00\uc838\uc628 \uac83\uc785\ub2c8\ub2e4 <code>\ucf54\uc5b4.\uace0\uac1d.\ube0c\ub79c\uce58_\ucf54\ub4dc<\/code>\ubcc0\ud615\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc785\ub2c8\ub2e4.<\/li>\n<li><code>\ucf54\uc5b4 \ud2b8\ub79c\uc7ad\uc158 \uc0c1\ud0dc<\/code> \uadf8\ub9ac\uace0 <code>\uace0\uac1d ID<\/code> \uc870\uc778 \ud0a4\ub294 \ub300\uc0c1 \ud589\uc5d0 \uc9c1\uc811 \ud3ec\ud568\ub418\uc9c0\ub294 \uc54a\uc9c0\ub9cc, \ub300\uc0c1 \ud589\uc758 \ubaa8\ub4e0 \ud589\uc744 \uad6c\uc131\ud558\ub294 \ub370 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. SQLFlow\ub294 \uc774\ub7ec\ud55c \ub0b4\uc6a9\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uae30\ub85d\ud569\ub2c8\ub2e4. <strong>\uac04\uc811 \ud608\ud1b5<\/strong>.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\uc9c1\uc811 \uacc4\ubcf4 vs. \uac04\uc811 \uacc4\ubcf4: \uac10\uc0ac\uc5d0 \uc911\uc694\ud55c \uc774\uc720<\/h2>\n\n\n\n<p>SQLFlow\ub294 \uad6c\ubcc4\ud569\ub2c8\ub2e4 <strong>\uc9c1\uacc4 \ud608\ud1b5<\/strong> (\uc6d0\ubcf8 \uc5f4\uc758 \uac12\uc774 \ub300\uc0c1 \uc5f4\ub85c \uc804\ub2ec\ub429\ub2c8\ub2e4) <strong>\uac04\uc811 \ud608\ud1b5<\/strong> (\uc5f4\uc740 \ub2e4\uc74c\uc744 \ud1b5\ud574 \uacb0\uacfc\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.) <code>\uc5b4\ub514<\/code> \uc808, <code>\uac00\uc785\ud558\ub2e4<\/code> \uc0c1\ud0dc, <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code>(\ub610\ub294 \uc9d1\uacc4). \uc774 \ub450 \uac00\uc9c0\ub294 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uac1c\ubcc4\uc801\uc73c\ub85c \uc804\ud658\ud560 \uc218 \uc788\uc73c\uba70, \ub300\ubd80\ubd84\uc758 \uacbd\uc7c1 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \uc804\ud600 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uac10\uc0ac\uc778\uc5d0\uac8c \uc788\uc5b4 \uadf8 \ucc28\uc774\ub294 \uc774\ub860\uc801\uc778 \ubb38\uc81c\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uc704\uc758 \ubcd1\ud569\uc5d0\uc11c, \ub9cc\uc57d <code>t.\uc0c1\ud0dc<\/code> \ucf54\ub4dc\uac00 \uc0c1\uc704\ub85c \ub2e4\uc2dc \ub9e4\ud551\ub418\uace0 \ubaa8\ub4e0 \uc794\uc561\uc774 \uc720\uc9c0\ub429\ub2c8\ub2e4. <code>dw.\uace0\uac1d_\uc794\uc561<\/code> \ubcc0\ud654 \u2014 \ube44\ub85d \uac12\uc774 \uc5c6\ub354\ub77c\ub3c4 <code>\uc0c1\ud0dc<\/code> \ud45c\uc5d0 \ub098\ud0c0\ub098\ub294 \uacbd\uc6b0\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc9c1\uc811 \uacc4\ud1b5\ub9cc \uace0\ub824\ud558\uba74 \ud574\ub2f9 \uc758\uc874\uc131\uc744 \ub193\uce58\uac8c \ub418\uc9c0\ub9cc, \uaddc\uc81c \uae30\uad00\uc5d0\uc11c &quot;\ubcf4\uace0\ub41c \uc218\uce58\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\ub294 \uc694\uc778\uc740 \ubb34\uc5c7\uc778\uac00?&quot;\ub77c\uace0 \uc9c8\ubb38\ud560 \ub54c\ub294 \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ub9ac\ub2c8\uc9c0\ub97c \uc0ac\uc6a9\ud558\uc5ec DB2\uc5d0\uc11c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uacc4\ud68d\ud569\ub2c8\ub2e4.<\/h2>\n\n\n\n<p>DB2\uac00 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc18c\uc2a4\uc778 \uacbd\uc6b0, \ub9ac\ub2c8\uc9c0\ub294 \ubc94\uc704\ub97c \uc9c0\uc815\ud558\ub294 \ub3c4\uad6c\uc785\ub2c8\ub2e4. \uc804\uccb4 \ud658\uacbd\uc744 \uc2a4\uce94\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uc9c4\uc815\ud55c \uc758\uc874\uc131 \uadf8\ub798\ud504<\/strong> \u2014 \uc5b4\ub5a4 \ubcf4\uae30, \uc791\uc5c5 \ubc0f \ub2e4\uc6b4\uc2a4\ud2b8\ub9bc \ucd94\ucd9c\uc774 \uc2e4\uc81c\ub85c \uac01 \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\ub294\uc9c0 \ud30c\uc545\ud558\uc5ec \uc774\ub3d9 \uc21c\uc11c\ub97c \uc815\ud558\uace0 \ub370\uc774\ud130 \uc804\uc1a1 \uc911\uc5d0 \uc911\ub2e8\ub418\ub294 \uac83\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub370\ub4dc\ucf54\ub4dc \uc2dd\ubcc4<\/strong> \u2014 \uc77d\uc5b4\ub4e4\uc774\ub294 \ub0b4\uc6a9\uc774 \uc5c6\ub294 \uac1d\uccb4\ub294 \ub9c8\uc774\uadf8\ub808\uc774\uc158\ubcf4\ub2e4\ub294 \ud3d0\uae30 \ub300\uc0c1\uc73c\ub85c \uace0\ub824\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\uc591\uce21 \uac80\uc99d<\/strong> SQLFlow\ub294 DB2 \uc678\uc5d0\ub3c4 Snowflake, BigQuery, Redshift, Databricks, PostgreSQL \ub4f1 39\uac00\uc9c0 \ubc29\uc5b8\uc744 \uc9c0\uc6d0\ud558\ubbc0\ub85c \ub300\uc0c1 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc7ac\uc791\uc131\ub41c SQL\uc744 \ubd84\uc11d\ud558\uace0 \uc7ac\uc791\uc131 \uc804\ud6c4\uc758 SQL \uacc4\ubcf4\ub97c \ube44\uad50\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc5ec\ub7ec \uae30\uc874 \ud50c\ub7ab\ud3fc\uc744 \ud55c \ubc88\uc5d0 \ud1b5\ud569\ud558\ub294 \ud300\uc740 \ubaa8\ub4e0 \uc5d4\uc9c4\uc5d0\uc11c \ub3d9\uc77c\ud55c \uc6cc\ud06c\ud50c\ub85c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uad00\ub828 \ud398\uc774\uc9c0\ub97c \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">Oracle \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.gudusoft.com\/ko\/%ed%85%8c%eb%9d%bc%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">\ud14c\ub77c\ub370\uc774\ud130 \ub370\uc774\ud130 \uacc4\ubcf4<\/a>\uc774\ub294 \ud574\ub2f9 \ubc29\uc5b8\ub4e4\uc5d0 \ub300\ud574 \ub3d9\uc77c\ud55c \uc811\uadfc \ubc29\uc2dd\uc744 \ub2e4\ub8e8\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ubc30\ud3ec \ubc29\uc2dd: \uaddc\uc81c \ub300\uc0c1 DB2 \ud658\uacbd\uc758 \uacbd\uc6b0 \uc628\ud504\ub808\ubbf8\uc2a4 \ubc30\ud3ec<\/h2>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 DB2 \ud658\uacbd\uc740 SQL \ud14d\uc2a4\ud2b8\uac00 \ub124\ud2b8\uc6cc\ud06c \uc678\ubd80\ub85c \uc720\ucd9c\ub420 \uc218 \uc5c6\ub294 \ud658\uacbd\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/a> Docker \ub610\ub294 Kubernetes \ud658\uacbd\uc5d0\uc11c \uc644\uc804\ud788 \uc0ac\uc6a9\uc790 \uc778\ud504\ub77c \ub0b4\uc5d0\uc11c \uc2e4\ud589\ub418\uba70, \uc644\ubcbd\ud55c \uc5d0\uc5b4\uac2d \uc124\uce58\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4. SQL \ub370\uc774\ud130\ub294 \ub124\ud2b8\uc6cc\ud06c\ub97c \ubc97\uc5b4\ub098\uc9c0 \uc54a\uc73c\uba70, SQLFlow\ub294 \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub97c \uc5b4\ub514\uc5d0\uc11c\ub3c4 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uac00\uaca9\uc740 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ucffc\ub9ac \ub610\ub294 \ubdf0 \uccb4\uc778 \ucd94\uc801\ub9cc \ud544\uc694\ud55c \ud300\uc740 SQLFlow Cloud \ubb34\ub8cc \ud2f0\uc5b4(\ud504\ub9ac\ubbf8\uc5c4\uc740 \uc6d4 49.99\ub2ec\ub7ec, $)\ub85c \uc2dc\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec \uc2dc\uc5d0\ub294 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uac00 \ucd94\uac00\ub429\ub2c8\ub2e4. <strong>DataHub, Microsoft Purview \ubc0f OpenMetadata<\/strong>\ub530\ub77c\uc11c DB2 \uacc4\ubcf4\ub294 \uc774\ubbf8 \uc2e4\ud589 \uc911\uc778 \uce74\ud0c8\ub85c\uadf8\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9 \ud398\uc774\uc9c0<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc774 \ubc29\ubc95\uc740 \ub2e4\ub978 \uc811\uadfc \ubc29\uc2dd\uacfc \ube44\uad50\ud588\uc744 \ub54c \uc5b4\ub5a4 \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\uae4c?<\/h2>\n\n\n\n<p>Collibra, Atlan, DataHub\uc640 \uac19\uc740 \uce74\ud0c8\ub85c\uadf8 \uc6b0\uc120 \ud50c\ub7ab\ud3fc\uc740 \uac70\ubc84\ub10c\uc2a4 \uc6cc\ud06c\ud50c\ub85c, \uc18c\uc720\uad8c \ubc0f \ube44\uc988\ub2c8\uc2a4 \uc6a9\uc5b4\uc9d1 \uad00\ub9ac\uc5d0 \ud0c1\uc6d4\ud558\uc9c0\ub9cc, \ub370\uc774\ud130\ub97c \ucc44\uc6b8 \uacc4\ubcf4 \uc18c\uc2a4\uac00 \ud544\uc694\ud558\uba70, DB2 \uc9c0\uc6d0\uc740 \uc77c\ubc18\uc801\uc778 SQL \ud30c\uc2f1\uc774 \uc81c\ub300\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4. \uc624\ud508 \uc18c\uc2a4 \ud30c\uc11c\ub85c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uac83\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4. <code>sqllineage<\/code> \uadf8\ub9ac\uace0 <code>sqlglot<\/code> \uac04\ub2e8\ud55c SELECT \ubc0f INSERT \ubb38\uc744 \uc798 \ucc98\ub9ac\ud569\ub2c8\ub2e4. DB2 <code>\ubcd1\ud569<\/code>\uc2a4\ud0dd\ud615 \ubdf0\uc640 SQL PL \ub8e8\ud2f4\uc740 \ubc29\uc5b8 \ucda9\uc2e4\ub3c4\uac00 \uadf8\ub798\ud504\uc758 \uc644\uc131\ub3c4\ub97c \uacb0\uc815\ud558\ub294 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. SQLFlow\uc758 DB2 \ud30c\uc11c\ub294 \uc57d 20\ub144\uac04\uc758 \uc0c1\uc6a9 \ud30c\uc11c \uac1c\ubc1c\uc744 \ud1b5\ud574 \ub2e4\ub4ec\uc5b4\uc9c4 39\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ubb38\ubc95 \uc911 \ud558\ub098\uc774\uba70, \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub97c \ud1b5\ud574 \uae30\uc874 \uce74\ud0c8\ub85c\uadf8\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294 DB2 \uacc4\ubcf4 \uc5d4\uc9c4\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacf5\uc815\ud55c \ud14c\uc2a4\ud2b8 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \ubcf5\uc7a1\ud55c DB2 \ubc30\uce58 \uc791\uc5c5\uc744 SQLFlow\ub97c \ud1b5\ud574 \uc2e4\ud589\ud574 \ubcf4\uc138\uc694. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=db2-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uacb0\uacfc\uac00 \ub098\uc624\ub294\uc9c0 \ubcf4\uc138\uc694.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 IBM DB2\ub97c \uc9c0\uc6d0\ud569\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. DB2\ub294 SQLFlow\uc5d0\uc11c \uc804\uc6a9 \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\ub294 39\uac1c \ubc29\uc5b8 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. SQLFlow\ub294 DB2 \ubdf0, MERGE \ubb38, \uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd(CTE) \ubc0f SQL PL \uad6c\ubb38\uc744 \ud30c\uc2f1 \uac00\ub2a5\ud55c SQL\ub85c \ucc98\ub9ac\ud558\uace0, \uc774 \ubaa8\ub4e0 \uc694\uc18c\uc5d0 \uac78\uccd0 \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 DB2 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud574\uc57c \ud558\ub098\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ud14d\uc2a4\ud2b8\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c JDBC\ub97c \ud1b5\ud574 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \uc5d0\ub514\uc158\uc758 \uacbd\uc6b0, SQL \ud14d\uc2a4\ud2b8\uc870\ucc28\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 \uc720\uc9c0\ub418\uba70, \uc5d0\uc5b4\uac2d \ud658\uacbd\uc5d0\uc11c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub97c \uc0ac\uc6a9\ud558\uc5ec DB2 MERGE \ubb38\uc744 \ud1b5\ud55c \ucd94\uc801 \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. MERGE\uc758 UPDATE \ubc0f INSERT \ubd84\uae30 \ubaa8\ub450 \ubd84\uc11d\ub418\uba70, USING \uc11c\ube0c\ucffc\ub9ac\uc5d0\uc11c \uac01 \ub300\uc0c1 \uc5f4\uae4c\uc9c0\uc758 \uc5f4 \uc218\uc900 \uacc4\ubcf4\uac00 \uae30\ub85d\ub418\uace0, \uc870\uc778 \ud0a4\uc640 \ud544\ud130 \uc5f4\uc5d0 \ub300\ud55c \uac04\uc811 \uacc4\ubcf4\ub3c4 \uae30\ub85d\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub9ac\ub2c8\uc9c0(Lineage)\uac00 DB2\uc5d0\uc11c \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc744\uae4c\uc694?<\/h3>\n\n\n<p>\ub124. \ub9ac\ub2c8\uc9c0 \uc2a4\uce94\uc744 \ud1b5\ud574 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc21c\uc11c\ub97c \uc815\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc2e4\uc81c \uc885\uc18d\uc131 \uadf8\ub798\ud504\ub97c \ud655\uc778\ud560 \uc218 \uc788\uace0, \uc774\uc2dd\ud558\ub294 \ub300\uc2e0 \ud3d0\uae30\ud560 \uc218 \uc788\ub294 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uac1d\uccb4\ub97c \uc2dd\ubcc4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c SQLFlow\ub294 Snowflake, BigQuery, Redshift, Databricks \ub4f1\ub3c4 \ud30c\uc2f1\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc7ac\uc791\uc131 \ud6c4 \ub300\uc0c1 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ub9ac\ub2c8\uc9c0\ub97c \uac80\uc99d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">DB2 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c DataHub, Purview \ub610\ub294 OpenMetadata\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec\uc5d0\ub294 DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uc640 JSON \ubc0f CSV \ub0b4\ubcf4\ub0b4\uae30, \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud1b5\ud569\uc744 \uc704\ud55c REST API\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">DB2\uc6a9 SQLFlow \ube44\uc6a9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/h3>\n\n\n<p>SQLFlow Cloud\ub294 \ubb34\ub8cc\ub85c \uc2dc\uc791\ud558\uba70, \ud504\ub9ac\ubbf8\uc5c4 \ubc84\uc804\uc740 \uc6d4 $49.99\uc785\ub2c8\ub2e4. SQLFlow On-Premise\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615(DB2\ub294 \ud558\ub098\uc758 \uc720\ud615\uc73c\ub85c \uac04\uc8fc)\ub2f9 \uc6d4 $500 \ub610\ub294 \uc77c\ud68c\uc131 $4,800\uc774\uba70, \ub450 \ub300\uc758 \uc11c\ubc84\uc5d0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\uc740 \uac01\uac01 \uc6d4 $100 \ub610\ub294 \uc77c\ud68c\uc131 $1,000\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">DB2 \ud658\uacbd\uc744 \uc9c0\ub3c4\uc5d0 \ud45c\uc2dc\ud558\uc138\uc694<\/h2>\n\n\n<p>\ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 DB2 \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uac70\ub098, \uc628\ud504\ub808\ubbf8\uc2a4 \ud658\uacbd \uc804\uccb4\ub97c \uc2a4\uce94\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uc800\ud76c\uc640 \uc0c1\ub2f4\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=db2-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/db2-data-lineage\\\/\",\n            \"description\": \"Automated data lineage for IBM DB2: parses DB2 views, MERGE statements, CTEs, and SQL PL to produce interactive column-level lineage diagrams for audits and migration planning.\",\n            \"featureList\": \"DB2 dialect parser, column-level lineage, indirect\\\/impact lineage, MERGE analysis, CTE and view resolution, JDBC metadata import, REST API, DataHub\\\/Purview\\\/OpenMetadata export\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow support IBM DB2?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. DB2 is one of 39 dialects with a dedicated parser in SQLFlow. It handles DB2 views, MERGE statements, common table expressions, and SQL PL constructs as parseable SQL, producing column-level lineage across all of them.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to the data in my DB2 tables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL text and optionally reads schema metadata over JDBC. It never reads table rows. With the On-Premise edition, even the SQL text stays inside your network, including air-gapped environments.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through a DB2 MERGE statement?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Both the UPDATE and INSERT branches of a MERGE are analyzed, with column-level lineage from the USING subquery into each target column, and indirect lineage recorded for join keys and filter columns.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can lineage help us migrate off DB2?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. A lineage scan gives you the real dependency graph for sequencing the migration, identifies unused objects you can retire instead of porting, and because SQLFlow also parses Snowflake, BigQuery, Redshift, Databricks, and more, lets you verify lineage on the target platform after the rewrite.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I export DB2 lineage to DataHub, Purview, or OpenMetadata?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Enterprise deployments include export adapters for DataHub, Microsoft Purview, and OpenMetadata, plus JSON and CSV export and a REST API for custom integrations.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How much does SQLFlow cost for DB2?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SQLFlow Cloud starts free; premium is $49.99\\\/month. SQLFlow On-Premise is $500\\\/month or $4,800 one-time per selected database type (DB2 counts as one type), installable on two servers, with additional database types at $100\\\/month or $1,000 one-time each.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>DB2 data lineage is the column-level map of how data moves through your IBM DB2 SQL: which source columns feed each view, warehouse table, and report extract, and through which joins, filters, expressions, and MERGE branches. Gudu SQLFlow builds that map automatically: it parses your DB2 SQL with a dedicated DB2 dialect parser and renders an interactive, drillable lineage diagram, with structured lineage data available as JSON, CSV, PNG, or over a REST API. Try it in 30 seconds: paste any DB2 query into the free online SQL lineage visualizer, select the DB2 dialect, and watch the column-level diagram appear.\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6763"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=6763"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6763\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}