{"id":3105,"date":"2016-04-11T10:50:55","date_gmt":"2016-04-11T07:50:55","guid":{"rendered":"http:\/\/koddit.com\/?p=3105"},"modified":"2016-04-11T10:52:57","modified_gmt":"2016-04-11T07:52:57","slug":"informatica-pushdown-optimization","status":"publish","type":"post","link":"https:\/\/blog.koddit.com\/en\/genel\/informatica-pushdown-optimization\/","title":{"rendered":"Informatica- PushDown Optimization"},"content":{"rendered":"

Informatica PushDown Optimizasyon Nedir?<\/strong><\/h2>\n

Merhabalar, bug\u00fcn sizlere Informatica’n\u0131n \u00e7okta bilinmeyen\u00a0\u00f6zelliklerinden biri olan PushDown Optimization’dan bahsedece\u011fim.<\/p>\n

Push Down\u00a0Optimizasyon’<\/strong>\u0131n amac\u0131 iyi performans elde etmek i\u00e7in sunucular aras\u0131ndaki y\u00fck\u00fc dengelemektir. Yani Informatica’da yapt\u0131\u011f\u0131m\u0131z mapping’lerin Informatica Server’\u0131ndaki y\u00fck\u00fcn\u00fc azaltmak ve yap\u0131lmas\u0131 gereken i\u015fi bir nevi Database’e yapt\u0131rmakt\u0131r.<\/p>\n

\u015eimdi a\u015fa\u011f\u0131daki resimli \u00f6rneklerle bunu nas\u0131l yapt\u0131\u011f\u0131m\u0131za bakal\u0131m ..\u00a0<\/strong><\/em><\/h4>\n

\"11\"

\u00a0<\/strong><\/em><\/p>\n

 <\/p>\n

To_Source<\/strong><\/em>\u00a0\u00a0ya da To_Target<\/strong><\/em>\u00a0\u00a0olarak \u00a0se\u00e7ti\u011fimizde \u00a0Informatica\u00a0Mapping’inde \u00a0 \u00a0kulland\u0131\u011f\u0131m\u0131z transformation’lar\u0131\u00a0SQL \u00a0sorgu\u00a0mant\u0131\u011f\u0131na \u00e7evirir ve\u00a0hedef veritaban\u0131na SQL \u00a0sorgular\u0131 \u00a0g\u00f6nderilir.\"8888\"

 <\/p>\n

<\/h3>\n

3<\/strong> \u00e7e\u015fit PushDown Optimization vard\u0131r :<\/h3>\n

1) Source-side PushDown Optimization<\/strong>\u00a0<\/strong><\/p>\n

Source Side : Sorguya \u00e7evirebildi\u011fi transformation’lar\u0131 DB’ye g\u00f6ndermek \u00fczere sorguya \u00e7eviriyor , \u00e7eviremedi\u011fi transformationlarda(Rank Transformation , Mapplet gibi) ya da farkl\u0131 veritabanlar\u0131ndan gelen source’lar\u0131 gruplayamad\u0131\u011f\u0131 i\u00e7in kesiliyor.<\/p>\n

2) Target-side PushDown Optimization<\/strong><\/p>\n

Target Side : Workflow\u2019da session baz\u0131nda ayarlan\u0131r. Target’tan ba\u015flayarak Source’a do\u011fru PushDown Optimization\u00a0yapar.<\/p>\n

3)\u00a0Full PushDown Optimization<\/strong><\/p>\n

Full Side : Dikkat edilmesi gereken nokta Mapping’te kullan\u0131lan\u00a0Source’lar\u0131n ayn\u0131 DB’de olmas\u0131 ko\u015fuludur. Yoksa Full PushDown Optimization yap\u0131lamaz.<\/p>\n

\u00d6rne\u011fin bir Products<\/strong> tablomuz olsun , bunlar\u0131n\u00a0Client_No, Product_No, Principle_Amount<\/em>\u00a0alanlar\u0131 olsun. Informatica’da PushDown Optimization yapmak i\u00e7in;<\/p>\n

To source’<\/strong>u\u00a0<\/strong>se\u00e7ti\u011fimizde \u00fcretece\u011fi sorgu ,<\/p>\n

select client_no , product_no , sum (principle_amount) from products\r\ngroup by client_no , product_no<\/pre>\n
To Target<\/strong>\u2019\u0131 se\u00e7ti\u011fimizde\u00a0\u00fcretece\u011fi sorgu\u00a0\u00a0a\u015fa\u011f\u0131daki gibi olacakt\u0131r.<\/span><\/p>\n
insert into dummy as\r\nselect client_no , product_no , sum (principle_amount)\r\nfrom products<\/pre>\n
\u015eimdi bir ba\u015fka \u00f6rne\u011fi inceleyelim\u00a0, Workflow seviyesinde ilgili session.\u0131n\u0131n bize d\u00f6nd\u00fcrd\u00fc\u011f\u00fc sorguyu,<\/p>\n
    \n
  1. ad\u0131m PushDown Option<\/strong><\/em> se\u00e7ene\u011fi (To_Source – To-Target – Full ) se\u00e7ip ,<\/li>\n
  2. ad\u0131m Preview Result For Connection’\u0131\u00a0<\/strong><\/em>se\u00e7tikten sonra a\u015fa\u011f\u0131daki gibi bir yap\u0131y\u0131 g\u00f6r\u00fcnt\u00fclemi\u015f oluruz.<\/li>\n<\/ol>\n
     <\/p>\n
    \"FFF\"
    Olu\u015fturdu\u011fu sorgular a\u015fa\u011f\u0131daki gibi Group1<\/strong><\/em> ve Group 2<\/strong><\/em> \u015feklinde ayr\u0131lm\u0131\u015ft\u0131r. Burada\u00a0Group_1<\/strong>‘in temel mant\u0131\u011f\u0131 , Group_1<\/strong>\u00a0\u00a0source.lar\u0131n Db’leri ayn\u0131 , Group_2<\/strong>‘deki source.lar\u0131n DB.leri ayn\u0131 oldu\u011fu i\u00e7in bunlar\u0131 kendi aras\u0131nda grupland\u0131rm\u0131\u015ft\u0131r. Sorguya d\u00f6n\u00fc\u015ft\u00fcrebildi\u011fi transformationlar\u0131n sorgusunu da\u00a0a\u015fa\u011f\u0131daki \u015fekilde g\u00f6rebiliriz.<\/p>\n
    Group 1<\/strong> :<\/p>\n
    SELECT * FROM\r\nC_TABLOSU INNER JOIN D_TABLOSU ON (C_TABLOSU.ID =D_TABLOSU.ID) RIGTH OUTER JOIN E_TABLOSU ON (E_TABLOSU.ID = C_TABLOSU.ID)<\/pre>\n
    Group\u00a02<\/strong>:<\/span><\/p>\n
    SELECT * FROM\u00a0\r\nA_TABLOSU LEFT JOIN B_TABLOSU ON (A_TABLOSU.ID = B_TABLOSU.ID)\u00a0\r\n<\/pre>\n
    NOT<\/strong>:\u00a0Target-Side se\u00e7ti\u011fimizde , ilgili session.\u0131n\u0131n Target’\u0131\u00a0Bulk<\/strong> <\/em>de\u011fil Normal<\/strong> <\/em>olarak y\u00fcklenmesi gerekmektedir. Yoksa\u00a0“No PushDown Optimization is possible. Pushdown optimization to the target stops at the target [X] because bulk loading cannot be used with target-side pushdown optimization<\/em>.” \u015feklinde bir hata ile kar\u015f\u0131la\u015fabiliriz.<\/p>\n
    \u00a0\"777\"
    De\u011ferli bilgilerini bizlerle payla\u015ft\u0131\u011f\u0131 i\u00e7in Kaan \u00dclvan’a te\u015fekk\u00fcr ederim.\u00a0\u015eimdilik bu kadar bir sonraki yaz\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere herkese\u00a0BigData’l\u0131 g\u00fcnler \ud83d\ude42<\/p>","protected":false},"excerpt":{"rendered":"
    Informatica PushDown Optimizasyon Nedir? Merhabalar, bug\u00fcn sizlere Informatica’n\u0131n \u00e7okta bilinmeyen\u00a0\u00f6zelliklerinden biri olan PushDown Optimization’dan bahsedece\u011fim. Push Down\u00a0Optimizasyon’\u0131n amac\u0131 iyi performans elde etmek i\u00e7in sunucular aras\u0131ndaki y\u00fck\u00fc dengelemektir. Yani Informatica’da yapt\u0131\u011f\u0131m\u0131z mapping’lerin Informatica Server’\u0131ndaki y\u00fck\u00fcn\u00fc azaltmak ve yap\u0131lmas\u0131 gereken i\u015fi bir nevi Database’e yapt\u0131rmakt\u0131r. \u015eimdi a\u015fa\u011f\u0131daki resimli \u00f6rneklerle bunu nas\u0131l yapt\u0131\u011f\u0131m\u0131za bakal\u0131m ..\u00a0 \u00a0 Workflow seviyesine […]<\/p>","protected":false},"author":12,"featured_media":3160,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[228,248,247],"class_list":["post-3105","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","tag-informatica","tag-powerdesigner","tag-pushdown-optimizasyon"],"yoast_head":"\nInformatica- PushDown Optimization - Koddit<\/title>\n<meta name=\"description\" content=\"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.koddit.com\/en\/genel\/informatica-pushdown-optimization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Informatica- PushDown Optimization - Koddit\" \/>\n<meta property=\"og:description\" content=\"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.koddit.com\/en\/genel\/informatica-pushdown-optimization\/\" \/>\n<meta property=\"og:site_name\" content=\"Koddit\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-11T07:50:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-04-11T07:52:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.koddit.com\/wp-content\/uploads\/2016\/04\/wwww.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Koddit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Koddit\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/\"},\"author\":{\"name\":\"Koddit\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\"},\"headline\":\"Informatica- PushDown Optimization\",\"datePublished\":\"2016-04-11T07:50:55+00:00\",\"dateModified\":\"2016-04-11T07:52:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/\"},\"wordCount\":456,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"keywords\":[\"informatica\",\"PowerDesigner\",\"PushDown Optimizasyon\"],\"articleSection\":[\"Genel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/\",\"url\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/\",\"name\":\"Informatica- PushDown Optimization - Koddit\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/#website\"},\"datePublished\":\"2016-04-11T07:50:55+00:00\",\"dateModified\":\"2016-04-11T07:52:57+00:00\",\"description\":\"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/blog.koddit.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informatica- PushDown Optimization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.koddit.com\/#website\",\"url\":\"https:\/\/blog.koddit.com\/\",\"name\":\"Koddit\",\"description\":\"Blog\",\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.koddit.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.koddit.com\/#organization\",\"name\":\"Koddit\",\"url\":\"https:\/\/blog.koddit.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png\",\"contentUrl\":\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png\",\"width\":\"176\",\"height\":\"65\",\"caption\":\"Koddit\"},\"image\":{\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\",\"name\":\"Koddit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g\",\"caption\":\"Koddit\"},\"description\":\"Koddit Yaz\u0131l\u0131m ve Dan\u0131\u015fmanl\u0131k info@koddit.com\",\"sameAs\":[\"https:\/\/blog.koddit.com\"],\"url\":\"https:\/\/blog.koddit.com\/en\/author\/koddit\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Informatica- PushDown Optimization - Koddit","description":"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.","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:\/\/blog.koddit.com\/en\/genel\/informatica-pushdown-optimization\/","og_locale":"en_US","og_type":"article","og_title":"Informatica- PushDown Optimization - Koddit","og_description":"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.","og_url":"https:\/\/blog.koddit.com\/en\/genel\/informatica-pushdown-optimization\/","og_site_name":"Koddit","article_published_time":"2016-04-11T07:50:55+00:00","article_modified_time":"2016-04-11T07:52:57+00:00","og_image":[{"width":450,"height":300,"url":"http:\/\/blog.koddit.com\/wp-content\/uploads\/2016\/04\/wwww.jpg","type":"image\/jpeg"}],"author":"Koddit","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Koddit","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#article","isPartOf":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/"},"author":{"name":"Koddit","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035"},"headline":"Informatica- PushDown Optimization","datePublished":"2016-04-11T07:50:55+00:00","dateModified":"2016-04-11T07:52:57+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/"},"wordCount":456,"commentCount":0,"publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"keywords":["informatica","PowerDesigner","PushDown Optimizasyon"],"articleSection":["Genel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/","url":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/","name":"Informatica- PushDown Optimization - Koddit","isPartOf":{"@id":"https:\/\/blog.koddit.com\/#website"},"datePublished":"2016-04-11T07:50:55+00:00","dateModified":"2016-04-11T07:52:57+00:00","description":"Bu yaz\u0131m\u0131zda PushDown Optimization nedir, PushDown Optimization konular\u0131n\u0131 inceliyor ve detayl\u0131 olarak anlat\u0131yoruz.","breadcrumb":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.koddit.com\/genel\/informatica-pushdown-optimization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/blog.koddit.com\/"},{"@type":"ListItem","position":2,"name":"Informatica- PushDown Optimization"}]},{"@type":"WebSite","@id":"https:\/\/blog.koddit.com\/#website","url":"https:\/\/blog.koddit.com\/","name":"Koddit","description":"Blog","publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.koddit.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blog.koddit.com\/#organization","name":"Koddit","url":"https:\/\/blog.koddit.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/","url":"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png","contentUrl":"https:\/\/blog.koddit.com\/wp-content\/uploads\/2023\/04\/koddit-logo.png","width":"176","height":"65","caption":"Koddit"},"image":{"@id":"https:\/\/blog.koddit.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035","name":"Koddit","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b61761f4f382d0c7491378564c2c447a?s=96&d=mm&r=g","caption":"Koddit"},"description":"Koddit Yaz\u0131l\u0131m ve Dan\u0131\u015fmanl\u0131k info@koddit.com","sameAs":["https:\/\/blog.koddit.com"],"url":"https:\/\/blog.koddit.com\/en\/author\/koddit\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/3105"}],"collection":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/comments?post=3105"}],"version-history":[{"count":0,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/3105\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media\/3160"}],"wp:attachment":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media?parent=3105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/categories?post=3105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/tags?post=3105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}