{"id":2373,"date":"2015-08-27T14:18:41","date_gmt":"2015-08-27T11:18:41","guid":{"rendered":"http:\/\/koddit.com\/?p=2373"},"modified":"2015-08-27T16:09:35","modified_gmt":"2015-08-27T13:09:35","slug":"informatica-powercenter-designer-ozellikleri","status":"publish","type":"post","link":"https:\/\/blog.koddit.com\/en\/genel\/informatica-powercenter-designer-ozellikleri\/","title":{"rendered":"Informatica PowerCenter Designer \u00d6zellikleri"},"content":{"rendered":"<p>Merhaba arkada\u015flar sizlere bu yaz\u0131mda Informatica PowerCenter Designer&#8217;\u0131n \u00f6zelliklerinin bir k\u0131sm\u0131n\u0131 \u00f6rneklerle anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m.<\/p>\n<p>G\u00fcn\u00fcm\u00fczde kaynak ad\u0131n\u0131 verdi\u011fimiz datalar\u0131m\u0131z \u00e7e\u015fitli ortamlarda(Oracle,SQL Server,IBM DB2,Excel,PDF,Flat File vs.) bulunur. Bazen b\u00f6yle\u00a0farkl\u0131 ortamlarda bulunan datan\u0131n tek bir platformda\u00a0toplanmas\u0131 gerekebilir.\u00a0<span>\u0130\u015fte tam da bu nokta da ETL dedi\u011fimiz yap\u0131 devreye giriyor. <\/span>Datawarehouse in en temel operasyonu olan ve implemetasyonda en b\u00fcy\u00fck b\u00fct\u00e7eyi alan k\u0131s\u0131m ETL ( <b>E(Extract &#8211; <\/b><strong>Ayr\u0131\u015ft\u0131rma<\/strong><b>) <\/b>, <b>T(Transform &#8211; <\/b><strong>D\u00f6n\u00fc\u015ft\u00fcrme<\/strong><b>) <\/b>, <b>L(Load &#8211; <\/b><strong>Y\u00fckleme<\/strong><b>) <\/b>) olarak adland\u0131r\u0131l\u0131r. <span>Kaynak database veya di\u011fer ortamlardan datan\u0131n al\u0131nmas\u0131, belli bir i\u015flemden ge\u00e7irilerek ve d\u00fczeltmeler yap\u0131larak DW yap\u0131s\u0131na uygun hale getirilmesi ve DW database i\u00e7erisine y\u00fcklenmesidir.\u00a0As\u0131l ama\u00e7 i\u015f zekas\u0131nda kullan\u0131lacak verinin en etkin kullan\u0131lacak hale getirilmesidir.<br \/>\n<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1.png\" alt=\"etl\" width=\"602\" height=\"367\" class=\"lazy aligncenter wp-image-2667 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1.png\" alt=\"etl\" width=\"602\" height=\"367\" class=\"aligncenter wp-image-2667 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1.png 602w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1-300x183.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/etl1-600x366.png 600w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/noscript><\/a><\/span><\/p>\n<p>ETL \u00fcr\u00fcn\u00fcn i\u00e7inde Power Center Designer, Workflow Manager ve Workflow Monitor ad\u0131nda uygulamalar vard\u0131r.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/1.png\" alt=\"1\" width=\"104\" height=\"25\" class=\"lazy aligncenter wp-image-2635 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/1.png\" alt=\"1\" width=\"104\" height=\"25\" class=\"aligncenter wp-image-2635 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/1.png 104w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/1-100x25.png 100w\" sizes=\"(max-width: 104px) 100vw, 104px\" \/><\/noscript><\/a><\/p>\n<h2 style=\"text-align: center\"><\/h2>\n<h2 style=\"text-align: left\">Repository Manager<\/h2>\n<p>Informatica\u2019n\u0131n haf\u0131zas\u0131 olarak d\u00fc\u015f\u00fcnebiliriz.<\/p>\n<p>-Folders<\/p>\n<p>-Object<\/p>\n<p>-Users and Groups i\u00e7erir.<\/p>\n<h2 style=\"text-align: left\">Designer<\/h2>\n<p>Etl mappinglerinin olu\u015fturuldu\u011fu ve tasarland\u0131\u011f\u0131 yerdir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/25.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/25.png\" alt=\"2\" width=\"575\" height=\"174\" class=\"lazy alignnone wp-image-2669 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/25.png\" alt=\"2\" width=\"575\" height=\"174\" class=\"alignnone wp-image-2669 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/25.png 575w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/25-300x91.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/noscript><\/a><\/p>\n<h2 style=\"text-align: left\">Workflow<\/h2>\n<p>\u0130\u015f ak\u0131\u015f\u0131n\u0131n sa\u011flanmas\u0131nda g\u00f6revlidir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/3-300x246.png\" alt=\"3\" width=\"300\" height=\"246\" class=\"lazy alignnone size-medium wp-image-2638\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/3-300x246.png\" alt=\"3\" width=\"300\" height=\"246\" class=\"alignnone size-medium wp-image-2638\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/3-300x246.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/3.png 502w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<h2 style=\"text-align: left\">Monitor<\/h2>\n<p>\u00c7al\u0131\u015ft\u0131r\u0131lan i\u015f ak\u0131\u015flar\u0131n\u0131n \u00e7al\u0131\u015fma durumlar\u0131 g\u00f6r\u00fcnt\u00fclenir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41.png\" alt=\"4\" width=\"742\" height=\"120\" class=\"lazy alignnone wp-image-2670 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41.png\" alt=\"4\" width=\"742\" height=\"120\" class=\"alignnone wp-image-2670 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41.png 742w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41-300x49.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/41-600x97.png 600w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/noscript><\/a><\/p>\n<p>Hata alan i\u015flerin ne hata ald\u0131klar\u0131 (Get Session Log), biten i\u015fler, \u00e7al\u0131\u015fma s\u00fcreleri bu uygulamadan izlenir.<\/p>\n<p>&nbsp;<\/p>\n<p>Basit bir mapping\u2019in en genel g\u00f6r\u00fcm\u00fc a\u015fa\u011f\u0131da ki gibidir :<\/p>\n<p>Source Defination \u00a0\u2192 \u00a0Source Qualifier \u00a0\u2192 Expression Transformation \u00a0\u2192 \u00a0Target<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9-1024x169.png\" alt=\"9\" width=\"798\" height=\"132\" class=\"lazy alignnone wp-image-2640 size-large\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9-1024x169.png\" alt=\"9\" width=\"798\" height=\"132\" class=\"alignnone wp-image-2640 size-large\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9-1024x169.png 1024w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9-300x50.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9-600x99.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9.png 1185w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/noscript><\/a><\/p>\n<p style=\"text-align: center\"><strong>\u00a0<\/strong><\/p>\n<h2 style=\"text-align: left\">Source Defination<\/h2>\n<p>Burada \u00a0kullanaca\u011f\u0131m\u0131z kaynak tabloyu mappingimize s\u00fcr\u00fckledi\u011fimiz de Source Defination Shortcut\u2019\u0131n\u0131<strong> <\/strong>olu\u015fturmu\u015f oluyoruz. Bu Source&#8217;un \u00a0yan\u0131nda otomatik olarak\u00a0<strong>Source Qualifier\u2019\u0131<\/strong> ile gelmektedir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/9.png\"><\/a> <a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/10.png\"><\/a><\/p>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/30.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/30.png\" alt=\"30\" width=\"524\" height=\"300\" class=\"lazy alignnone wp-image-2753 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/30.png\" alt=\"30\" width=\"524\" height=\"300\" class=\"alignnone wp-image-2753 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/30.png 524w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/30-300x172.png 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/noscript><\/a>\u00a0<\/strong><\/p>\n<h2 style=\"text-align: left\">Source Qualifier<\/h2>\n<p style=\"text-align: center\"><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/112.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/112.png\" alt=\"11\" width=\"578\" height=\"331\" class=\"lazy alignnone wp-image-2672 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/112.png\" alt=\"11\" width=\"578\" height=\"331\" class=\"alignnone wp-image-2672 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/112.png 578w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/112-300x172.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/noscript><\/a><\/p>\n<p><strong>Sql Query<\/strong> -&gt; Sorgular\u0131n seviyesine g\u00f6re modellenemeyen sorgular\u0131 direkt olarak buraya g\u00f6merek database gidip \u00e7ekmesini sa\u011flayabiliriz. Yani burada i\u015fi Informatica\u2019ya de\u011fil de Database\u2019e yapt\u0131rm\u0131\u015f oluyoruz. (Sql Override olarak tan\u0131mlanabilir.)<\/p>\n<p>SQ i\u00e7inde Genereate Sql dedi\u011fimizde, olu\u015fturdu\u011fu Sql\u2019i database\u2019e g\u00f6nderir ve ald\u0131\u011f\u0131 sonucu art\u0131k DB\u2019ye gitmeden kendi Informatica i\u00e7erisinde halletmeye devam eder.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27.png\" alt=\"27\" width=\"782\" height=\"312\" class=\"lazy alignnone wp-image-2709 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27.png\" alt=\"27\" width=\"782\" height=\"312\" class=\"alignnone wp-image-2709 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27.png 782w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27-300x120.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/27-600x239.png 600w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/noscript><\/a><\/p>\n<p>\u00d6nemli olan Ports k\u0131sm\u0131na select k\u0131sm\u0131nda yazan ifadeleri eklemi\u015f olmam\u0131zd\u0131r.<\/p>\n<p>Sorgumuzu SQ (Source Qualifier) i\u00e7erisinde ki SQL Query k\u0131sm\u0131na yap\u0131\u015ft\u0131r\u0131yoruz. Daha sonra sorgumuzda bulunan select ifadelerinin s\u0131ras\u0131na bakarak SQ portlar\u0131nda ayn\u0131 isimle ve data format\u0131yla ekliyoruz. Burada Source k\u0131sm\u0131 \u00f6nemli de\u011fil , ekledi\u011fin herhangi bir kaynak tablodan\u00a0data format\u0131n\u0131n ayn\u0131 oldu\u011fu bir item\u2019\u0131 \u00fczerine s\u00fcr\u00fckleyebiliriz. Dikkat etmemiz gereken SQ\u2018da olu\u015fturdu\u011fumuz portlardan bo\u015fta kalan yani input giri\u015fi olmayan kalmamal\u0131.<\/p>\n<p><strong>User Defined Join<\/strong> : Bir veya birden fazla source tabloyu \u00a0Primary\/Foreign Key alanlar\u0131 \u00fczerinden joinleme i\u015flemeni Joiner Transformation kullanmadan burada da yapabiliriz.<\/p>\n<p>NOT: Farkl\u0131 DB\u2019den gelen kay\u0131tlar bunun \u00fczerinden joinlenemez.\u00a0\u00d6rne\u011fin Sybase\u2019den gelen bir source ile Oracle \u2018dan gelen bir source ayn\u0131 SQ\u2019da joinlenemez.<\/p>\n<p><strong>Source Filter &#8211;<\/strong>&gt; Properties sekmesinde sorgumuzda Where ko\u015fulunda\u00a0bulunan Filtreleri &#8211; Ko\u015fullar\u0131 Source Filter k\u0131sm\u0131nda \u00a0tan\u0131ml\u0131yoruz.<\/p>\n<p><strong>Number Of Sorted Ports -&gt;<\/strong>Bunun kullan\u0131m\u0131 ise sortlamak istedi\u011fimiz alan\u0131 ilk s\u0131raya getirerek,<\/p>\n<p>Number Of Sorted Ports : 1 dedi\u011fimizde ilk alana g\u00f6re s\u0131ralar.<\/p>\n<p>Number Of Sorted Ports : 2 dedi\u011fimizde ilk iki alana g\u00f6re s\u0131ralama yapar.<\/p>\n<p><strong>Select distinct -&gt; <\/strong>E\u011fer bu ifadeyi aktif hale getirmek istersek\u00a0Select distinct \u00f6zelli\u011fini se\u00e7iyoruz. Datan\u0131n \u00e7oklamas\u0131 engellenir. Dezavantaj\u0131 distinct\u00a0edece\u011fi alan\u0131\u00a0kendisi belirler.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/12.png\"><\/a><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121.png\" alt=\"12\" width=\"613\" height=\"258\" class=\"lazy alignnone wp-image-2673 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121.png\" alt=\"12\" width=\"613\" height=\"258\" class=\"alignnone wp-image-2673 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121.png 613w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121-300x126.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/121-600x253.png 600w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/noscript><\/a><\/p>\n<p><strong>\u0130nput Port<\/strong> : Hi\u00e7bir porta ba\u011f\u0131ml\u0131 de\u011fildir. \u0130\u015flem olarak ilk olarak de\u011ferlendirilen porttur.<\/p>\n<p><strong>Variable Port<\/strong> : Input portunu referans alarak hesaplan\u0131r. Variable sadece o transformation i\u00e7inde kullan\u0131l\u0131r, ne input ne de output\u2019dur. Input portunu referans olarak kullan\u0131p sayd\u0131rma i\u015flemlerinde vs kullan\u0131labilir.<\/p>\n<p><strong>Output Port <\/strong>: Input Port ve Variable Port refereans al\u0131r. Transformation i\u00e7inde en son de\u011ferlendirilir.<\/p>\n<h2 style=\"text-align: left\">Expression Transformation<\/h2>\n<p>Data Convert \/ Kolon \u0130smi De\u011fi\u015ftirme \/ Kolona Spesifik de\u011fer atama<\/p>\n<p>Pasif bir transformation\u2019dur, yani giren-\u00e7\u0131kan sat\u0131r say\u0131s\u0131 e\u015fittir.<\/p>\n<p>Addition, Subtraction, Multiplication, Division, Concat, Uppercase conversion, lowercase conversion etc. yap\u0131labilir.<\/p>\n<p>Expression Row by Row i\u015flem yapar. Case\/when \u2013 decode vs de yap\u0131labilir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26-300x104.png\" alt=\"26\" width=\"300\" height=\"104\" class=\"lazy alignnone size-medium wp-image-2708\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26-300x104.png\" alt=\"26\" width=\"300\" height=\"104\" class=\"alignnone size-medium wp-image-2708\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26-300x104.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26-450x158.png 450w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/26.png 456w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/noscript><\/a><\/p>\n<p>Expression Transformation kullanarak data \u00fczerinde \u00a0yap\u0131labilecek i\u015flemler;<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/13.png\" alt=\"13\" width=\"281\" height=\"212\" class=\"lazy   wp-image-2645  alignright\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/13.png\" alt=\"13\" width=\"281\" height=\"212\" class=\"wp-image-2645  alignright\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/13.png 320w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/13-300x227.png 300w\" sizes=\"(max-width: 281px) 100vw, 281px\" \/><\/noscript><\/p>\n<ul>\n<li style=\"text-align: left\">Manipulation (de\u011fi\u015ftirme) i\u015flemleri \u00a0(LTRIM, CONCAT, UPPER, vs)<\/li>\n<li style=\"text-align: left\">Conversion (d\u00f6n\u00fc\u015ft\u00fcrme) i\u015flemleri \u00a0(TO_CHAR, TO_DECIMAL, \u00a0 \u00a0 \u00a0 \u00a0 TO_DATE, vs)<\/li>\n<li style=\"text-align: left\">Data temizleme ve d\u00fczenleme i\u015flemleri \u00a0(ISNULL, REPLACESTR, vs<\/li>\n<li style=\"text-align: left\">Matematiksel i\u015flemler \u00a0(LOG, POWER, vs)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Mapping \u00fczerinde Check-in ve Check-out :<\/strong><\/p>\n<p>Bir mapping \u00fczerinde de\u011fi\u015fiklik yapmak istedi\u011fimize mappingi mutlaka kendi DEV\u00a0ortam\u0131m\u0131zda \u00fczerimize almam\u0131z gerekmektedir. (Check-out)<\/p>\n<p>\u015e\u00f6yle ki;<\/p>\n<p>Mapping\u2019imize sa\u011f t\u0131klay\u0131p -&gt; Versioning -&gt; Check-out diyebiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251.png\" alt=\"25\" width=\"600\" height=\"359\" class=\"lazy   aligncenter wp-image-2700 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251.png\" alt=\"25\" width=\"600\" height=\"359\" class=\"aligncenter wp-image-2700 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251-300x180.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251-290x175.png 290w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript><\/a><strong>\u00a0 \u00a0 <\/strong><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/251.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/151.png\" alt=\"15\" width=\"248\" height=\"170\" class=\"lazy  wp-image-2675  alignright\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/151.png\" alt=\"15\" width=\"248\" height=\"170\" class=\"wp-image-2675  alignright\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/151.png 385w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/151-300x206.png 300w\" sizes=\"(max-width: 248px) 100vw, 248px\" \/><\/noscript><\/a><\/p>\n<p>Buraya da mapping\u2019in hangi kullan\u0131c\u0131 \u00fczerinde oldu\u011funu anlatmak i\u00e7in Comment k\u0131sm\u0131na yorum yazabiliriz.<\/p>\n<p>&nbsp;<\/p>\n<p>\u00dczerinde bulunan CheckOut\u2019lar\u0131 g\u00f6r\u00fcnt\u00fclemek i\u00e7in Versioning \u2192\u00a0Find Checkouts yap\u0131yoruz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161.png\" alt=\"16\" width=\"616\" height=\"204\" class=\"lazy  wp-image-2676 size-full aligncenter\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161.png\" alt=\"16\" width=\"616\" height=\"204\" class=\"wp-image-2676 size-full aligncenter\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161.png 616w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161-300x99.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/161-600x199.png 600w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/noscript><\/a><\/p>\n<p style=\"text-align: center\"><strong>\u21d3<\/strong><\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171.png\" alt=\"17\" width=\"445\" height=\"204\" class=\"lazy  wp-image-2677 size-full alignright\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171.png\" alt=\"17\" width=\"445\" height=\"204\" class=\"wp-image-2677 size-full alignright\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171.png 445w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171-300x138.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/171-316x145.png 316w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/noscript><\/a><\/p>\n<p>Burada all users \u0131 i\u015faretlersek di\u011fer kullan\u0131c\u0131lar\u0131n da \u00fczerine\u00a0ald\u0131klar\u0131 mapping\u2019leri g\u00f6rebiliriz.Di\u011fer kullan\u0131c\u0131lar\u0131n da i\u015flem yapmas\u0131n\u0131 istedi\u011fimiz de\u00a0Sa\u011f t\u0131klay\u0131p Check-In yapabiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181.png\" alt=\"18\" width=\"614\" height=\"136\" class=\"lazy alignnone wp-image-2678 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181.png\" alt=\"18\" width=\"614\" height=\"136\" class=\"alignnone wp-image-2678 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181.png 614w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181-300x66.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/181-600x133.png 600w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/noscript><\/a><br \/>\n<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/18.png\"><\/a><\/p>\n<p style=\"text-align: left\"><em>Mappinglerin g\u00f6sterim \u015fekilleri genel olarak 2 t\u00fcrl\u00fcd\u00fcr.<\/em><\/p>\n<ul>\n<li><strong>Arrange All<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19.png\" alt=\"19\" width=\"605\" height=\"130\" class=\"lazy alignnone wp-image-2652 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19.png\" alt=\"19\" width=\"605\" height=\"130\" class=\"alignnone wp-image-2652 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19.png 605w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19-300x64.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19-600x129.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/19-601x130.png 601w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/noscript><\/a><\/p>\n<ul>\n<li><strong>Arrange All Iconic<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20.png\" alt=\"20\" width=\"633\" height=\"233\" class=\"lazy alignnone wp-image-2653 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20.png\" alt=\"20\" width=\"633\" height=\"233\" class=\"alignnone wp-image-2653 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20.png 633w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20-300x110.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/20-600x221.png 600w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/noscript><\/a><\/p>\n<p>Bir mappingte var olan\u00a0alan\u0131n geldi\u011fi ya da gidece\u011fi yolu bulmak i\u00e7in\u00a0o alan \u00fczerinde sa\u011fa t\u0131klay\u0131p Select Link Path \u2192 Forward \/Backward diyip bulabiliriz.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211.png\" alt=\"21\" width=\"604\" height=\"172\" class=\"lazy alignnone wp-image-2654 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211.png\" alt=\"21\" width=\"604\" height=\"172\" class=\"alignnone wp-image-2654 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211.png 604w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211-300x85.png 300w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211-600x171.png 600w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/211-601x172.png 601w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/noscript><\/a><\/p>\n<p>Dip Not : Informatica da benim en \u00e7ok kulland\u0131\u011f\u0131m k\u0131s\u0131mlardan beri her t\u00fcrl\u00fc Fonksiyonlar\u0131n \u00f6zelliklerini ve kullan\u0131mlar\u0131n\u0131 anlatan Help \u2192\u00a0Contents\u2019dir.<\/p>\n<p><strong>\u00a0<a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/221.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/221.png\" alt=\"22\" width=\"525\" height=\"149\" class=\"lazy alignnone wp-image-2679 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/221.png\" alt=\"22\" width=\"525\" height=\"149\" class=\"alignnone wp-image-2679 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/221.png 525w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/221-300x85.png 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/noscript><\/a><\/strong><\/p>\n<h2 style=\"text-align: left\"><\/h2>\n<h2 style=\"text-align: left\">Target<\/h2>\n<p>Data\u2019n\u0131n Hedef\u2019e y\u00fcklenmesidir.<\/p>\n<p><a href=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/23.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/23.png\" alt=\"23\" width=\"573\" height=\"198\" class=\"lazy alignnone wp-image-2656 size-full\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/23.png\" alt=\"23\" width=\"573\" height=\"198\" class=\"alignnone wp-image-2656 size-full\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/23.png 573w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/23-300x104.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/noscript><\/a><\/p>\n<p>Target Tabloyu olu\u015fturmak i\u00e7in Expression \u2192\u00a0 Create and Target \u00a0\u2192 \u00a0Genereate \/ Execute Sql \u00a0Edit Sql script dedi\u011fimizde olu\u015fturulan Scripti al\u0131p database&#8217;de target tabloyu yarat\u0131yoruz.<\/p>\n<p>Sadece o tablonun alanlar\u0131n\u0131 almak i\u00e7in olu\u015fturdu\u011fumuz ge\u00e7ici target\u2019\u0131 tabloyu siliyoruz.(<em>Target \u2192\u00a0(sa\u011f click) Clear All<\/em>) DB de yaratt\u0131\u011f\u0131m\u0131z Import Edilmi\u015f olan Target\u2019\u0131 kullan\u0131yoruz.<\/p>\n<p>Expression Transformation&#8217;dan olu\u015fturulan Target\u2019\u0131n \u00a0kolon\u00a0isimleri ve data formatlar\u0131 Expresion ile ayn\u0131 ise Autolink By Name ile direk alanlar\u0131\u00a0birbirine ba\u011flayabiliriz.<\/p>\n<h2>Informatica Fonksiyonlar\u0131<\/h2>\n<p>Bu b\u00f6l\u00fcmde sizlere Informatica da kullan\u0131lan bir ka\u00e7 Fonksiyonu anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m. T\u00fcm Fonksiyonlar Expression\u2019\u0131n\u0131n Functions k\u0131sm\u0131nda All Functions klas\u00f6r\u00fcnde bulunuyor.<\/p>\n<ul>\n<li><span class=\"lang:default decode:true  crayon-inline\">CASE WHEN A.PHONE_TYPE IN (&#8216;X&#8217;, &#8216;Y&#8217;) THEN A.PHONE_TYPE ELSE &#8216;Z&#8217; END <\/span>\u00a0 Infortmatica&#8217;da\u00a0case-when fonksiyonu olamad\u0131\u011f\u0131 i\u00e7in bu yap\u0131y\u0131<span class=\"lang:default decode:true crayon-inline\">IIF(PHONE_TYPE=&#8217;X&#8217; OR PHONE_TYPE=&#8217;Y&#8217;, PHONE_TYPE, &#8216;Z&#8217;) \u00a0<\/span>\u015feklinde kullanabiliriz.<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">IIF(LINE_NO = 1, &#8216;AKTIF&#8217;, IIF(LINE_NO = 2, &#8216;MUSTERI&#8217;, NULL)) <\/span>\u00a0 \u0130\u00e7 i\u00e7e If fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">SUM(IIF(USER=&#8217;OP&#8217;, CNT,0))<\/span>\u00a0Aggragation Fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">GET_DATE_PART(data_date, &#8216;YYYY&#8217;)<\/span>\u00a0 Y\u0131l\u0131 parse etme fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">GET_DATE_PART(data_date, &#8216;MM&#8217;)<\/span>\u00a0Ay\u0131 parse etme fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">DECODE(SECURED,&#8217;Y&#8217;,&#8221;,IP)<\/span>\u00a0Decode fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">SUBSTR(MERCHANT,1,2)\u00a0<\/span>\u00a0Substr Fonskiyonu<\/li>\n<li>Infotmatica\u2019da Expression Transformation da between ifadesi olmad\u0131\u011f\u0131 i\u00e7in , e\u011fer select c\u00fcmleci\u011finde b\u00f6yle bir sorgu var ise bunu Between kullanmadan a\u015fa\u011f\u0131daki \u015fekilde \u00e7\u00f6zebiliriz :<span class=\"lang:default decode:true  crayon-inline\">YANIT_TARIHI BETWEEN &#8216;2015-01-01&#8217; AND &#8216;2015-05-31&#8217; <\/span>\u00a0 \u00a0\u015feklindeki ifadeyi \u00a0<span class=\"lang:default decode:true  crayon-inline\">IIF(YANIT_TARIHI &gt;=TO_DATE( &#8216;2015-01-01&#8217;, &#8216;YYYY.MM.DD&#8217;) AND YANIT_TARIHI &lt;= TO_DATE(&#8216;2015-05-31&#8217; , &#8216;YYYY.MM.DD&#8217;)<\/span><\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">REPLACESTR(TRUE,F,&#8217;Operasyon B\u00f6lgesi&#8217;,&#8221;)<\/span>\u00a0 Replace Fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">TO_DATE(to_char(GET_DATE_PART(STOK,&#8217;dd&#8217;) ||&#8217;\/&#8217; || GET_DATE_PART(STOK,&#8217;mm&#8217;) || &#8216;\/&#8217;|| GET_DATE_PART(STOK,&#8217;yyyy&#8217;)), &#8216;dd\/mm\/yyyy&#8217;) <\/span>\u00a0 To_Date fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">trunc(create_date)<\/span>\u00a0Trunc Fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">LTRIM(RTRIM(CEK,&#8217; &#8216;),&#8217; &#8216;)\u00a0<\/span>\u00a0 Trim Fonksiyonu Ltrim ve Rtrim fonksiyonlar\u0131 ile yap\u0131l\u0131r.<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">DATE_DIFF(sysdate, Max_effdate, &#8216;dd&#8217;)<\/span>\u00a0 Date_Diff kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplamada kullan\u0131l\u0131r.<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">to_char(RAPORLAMA_TARIHI,&#8217;dd\/mm\/yyyy&#8217;) <\/span>\u00a0 To_char fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">Decode(Adet,NULL,0,Adet) <\/span>\u00a0 Informatica&#8217;da NVL fonksiyonu yoktur, bunu decode yard\u0131m\u0131 ile yapabiliriz.<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">ISNULL(Group_Name) <\/span>\u00a0 ISNULL fonksiyonu<\/li>\n<li><span class=\"lang:default decode:true  crayon-inline\">TYPE\u00a0in(1,2) <\/span>\u00a0 ifadesi Informatica&#8217;da\u00a0<span class=\"lang:default decode:true  crayon-inline\">In(TYPE 1,2) <\/span>\u00a0In fonksiyonu kullan\u0131m\u0131.<\/li>\n<\/ul>\n<p>Sizlerle genelde en \u00e7ok kullan\u0131lan fonksiyonlar\u0131 payla\u015ft\u0131m tabi ki bunlar\u0131n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif\" data-original=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/24.png\" alt=\"24\" width=\"218\" height=\"424\" class=\"lazy alignleft wp-image-2662\" \/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/24.png\" alt=\"24\" width=\"218\" height=\"424\" class=\"alignleft wp-image-2662\" srcset=\"https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/24.png 218w, https:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/24-154x300.png 154w\" sizes=\"(max-width: 218px) 100vw, 218px\" \/><\/noscript><\/p>\n<p>d\u0131\u015f\u0131nda daha bir \u00e7ok fonksiyon\u00a0var bunlara All Functions \u00a0klas\u00f6r\u00fcnden ula\u015fabilirsiniz.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: left\"><em>Bir\u00a0di\u011fer\u00a0Informatica yaz\u0131s\u0131nda\u00a0g\u00f6r\u00fc\u015fmek \u00fczere \u015fimdilik ho\u015f\u00e7akal\u0131n \ud83d\ude42<\/em><\/h4>\n<p><strong><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Merhaba arkada\u015flar sizlere bu yaz\u0131mda Informatica PowerCenter Designer&#8217;\u0131n \u00f6zelliklerinin bir k\u0131sm\u0131n\u0131 \u00f6rneklerle anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m. G\u00fcn\u00fcm\u00fczde kaynak ad\u0131n\u0131 verdi\u011fimiz datalar\u0131m\u0131z \u00e7e\u015fitli ortamlarda(Oracle,SQL Server,IBM DB2,Excel,PDF,Flat File vs.) bulunur. Bazen b\u00f6yle\u00a0farkl\u0131 ortamlarda bulunan datan\u0131n tek bir platformda\u00a0toplanmas\u0131 gerekebilir.\u00a0\u0130\u015fte tam da bu nokta da ETL dedi\u011fimiz yap\u0131 devreye giriyor. Datawarehouse in en temel operasyonu olan ve implemetasyonda en b\u00fcy\u00fck [&hellip;]<\/p>","protected":false},"author":12,"featured_media":2743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Informatica PowerCenter Designer \u00d6zellikleri - Koddit<\/title>\n<meta name=\"description\" content=\"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target&#039;\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.\" \/>\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-powercenter-designer-ozellikleri\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Informatica PowerCenter Designer \u00d6zellikleri - Koddit\" \/>\n<meta property=\"og:description\" content=\"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target&#039;\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.koddit.com\/en\/genel\/informatica-powercenter-designer-ozellikleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Koddit\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-27T11:18:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-27T13:09:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/informatic.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"950\" \/>\n\t<meta property=\"og:image:height\" content=\"497\" \/>\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=\"7 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-powercenter-designer-ozellikleri\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/\"},\"author\":{\"name\":\"Koddit\",\"@id\":\"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035\"},\"headline\":\"Informatica PowerCenter Designer \u00d6zellikleri\",\"datePublished\":\"2015-08-27T11:18:41+00:00\",\"dateModified\":\"2015-08-27T13:09:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/\"},\"wordCount\":1444,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.koddit.com\/#organization\"},\"articleSection\":[\"Genel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/\",\"url\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/\",\"name\":\"Informatica PowerCenter Designer \u00d6zellikleri - Koddit\",\"isPartOf\":{\"@id\":\"https:\/\/blog.koddit.com\/#website\"},\"datePublished\":\"2015-08-27T11:18:41+00:00\",\"dateModified\":\"2015-08-27T13:09:35+00:00\",\"description\":\"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target'\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/blog.koddit.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informatica PowerCenter Designer \u00d6zellikleri\"}]},{\"@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 PowerCenter Designer \u00d6zellikleri - Koddit","description":"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target'\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.","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-powercenter-designer-ozellikleri\/","og_locale":"en_US","og_type":"article","og_title":"Informatica PowerCenter Designer \u00d6zellikleri - Koddit","og_description":"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target'\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.","og_url":"https:\/\/blog.koddit.com\/en\/genel\/informatica-powercenter-designer-ozellikleri\/","og_site_name":"Koddit","article_published_time":"2015-08-27T11:18:41+00:00","article_modified_time":"2015-08-27T13:09:35+00:00","og_image":[{"width":950,"height":497,"url":"http:\/\/blog.koddit.com\/wp-content\/uploads\/2015\/08\/informatic.jpg","type":"image\/jpeg"}],"author":"Koddit","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Koddit","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#article","isPartOf":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/"},"author":{"name":"Koddit","@id":"https:\/\/blog.koddit.com\/#\/schema\/person\/518a908da35b6c3549d25a0bda7a1035"},"headline":"Informatica PowerCenter Designer \u00d6zellikleri","datePublished":"2015-08-27T11:18:41+00:00","dateModified":"2015-08-27T13:09:35+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/"},"wordCount":1444,"commentCount":0,"publisher":{"@id":"https:\/\/blog.koddit.com\/#organization"},"articleSection":["Genel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/","url":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/","name":"Informatica PowerCenter Designer \u00d6zellikleri - Koddit","isPartOf":{"@id":"https:\/\/blog.koddit.com\/#website"},"datePublished":"2015-08-27T11:18:41+00:00","dateModified":"2015-08-27T13:09:35+00:00","description":"ETL nedir? Informatica Power Center Designer \u00d6zellikleri nelerdir? U\u00e7tan uca mapping i\u00e7in Source Defination, Source Qualifier, Expression, Target'\u0131n kullan\u0131m\u0131 ve Informatica Fonksiyonlar\u0131n\u0131 \u00f6rneklerle inceliyoruz.","breadcrumb":{"@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.koddit.com\/genel\/informatica-powercenter-designer-ozellikleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/blog.koddit.com\/"},{"@type":"ListItem","position":2,"name":"Informatica PowerCenter Designer \u00d6zellikleri"}]},{"@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\/2373"}],"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=2373"}],"version-history":[{"count":0,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/posts\/2373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media\/2743"}],"wp:attachment":[{"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/media?parent=2373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/categories?post=2373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.koddit.com\/en\/wp-json\/wp\/v2\/tags?post=2373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}