by Vincent Rainardi
In Informatica version 9, PowerCenter Metadata Manager can now read SSAS and SSRS metadata. Metadata Manager (MM) is a tool to document the data lineage. It interogates the ETL tool, the RDMBS, the reporting tools and the analytics tools to get their metadata. Then it finds out (automatically) where each piece of data is coming from. For example, if your DW/BI system consists of:
Source System in Oracle ETL in Informatica Data Warehouse (DW) in SQL Server Data Models in ERWin Reports in SSRS Cubes in SSASthen using Informatica 9 Metadata Manager you can create a diagram that explains:
From which column in the Source System each column in the DW is derived from (and vice versa) Which Transformation in which Informatica mapping does it #1 above (and vice versa) Which ERWin object is associated with each DW table (and vice versa) From which column in DW each attribute in the cube is derived from (and vice versa) From which column in DW each column in the SSRS report is derived from (and vice versa)At the highest level the diagram probably consists of 5 icons: Oracle – PowerCenter – DW – ERWin – SSRS – SSAS. If click the + sign on any icon, it opens up and show you the details. For example if you click on the DW it shows the tables, and if you click on a table, it shows the column. If you click on the SSRS icon, it shows the relevant reports, click on the reports and it shows the columns. Go here and scroll down to page 2 to see the screenshot of that diagram.
Data lineage diagram like that is indispensible and a must have in any data warehousing project. Sorry, any data warehousing project. It’s not for the sake of documentation, but more importantly it’s for impact analysis. You get to know in detail which objects will be affected if you modify the data type of column1 in table1 in the warehouse. The problem with data lineage, as with any documentation, is incorporating changes. Sure it’s up to scratch when your BI system went live, but after just 3 releases my experience shows that the documentation would usually lack behind. Hence we had to trace those columns manually. With data lineage tool like Metadata Manager we can point it to our system and it creates the diagram. It shows where the data flows to, in detail. Up to the reports and cubes.
.... The JUE-95LT Inmarsat Mini-C mobile earth terminal is designed for Ship Security Alert System use and provides two-way data/message ...
|
Phuket Security Boost in Terror Alert; Cruise Ship Hits Reef; Tourism Up in ... Phuketwan - Jan 01, 1970
table border=0 cellpadding=2 cellspacing=7 style=vertical-align:top;trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serif/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbr /div style=padding-top:0.8em;img alt= height=1 width=1 //divdiv class=lha href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNHNjUY2eTbPB99sdqQ0MG2a8wL-iwamp;url=http://phuketwan.com/tourism/terrorist-alert-sparks-confusion-tourism-thailand-acts-burma-phuket-events-15333/bPhuket bSecurity/b Boost in Terror bAlert/b; Cruise bShip/b Hits Reef; Tourism Up in b/b/b/abr /font size=-1bfont color=#6f6f6fPhuketwan/font/b/fontbr /font size=-1By Phuketwan Reporters afp Eight people are dead after cruise bship/b Costa Concordia hits a reef off the Italian coast, forcing the Italian coast guard to evacuate over 4000 people, according to Italian media reports. telegraph.co.uk Some leapt overboard b/b/fontbr /font size=-1 class=p/fontbr /font class=p size=-1a class=p href=http://news.google.com/news/more?ncl=d2YbcbAMgTEhKAMamp;ned=usnobrband morenbsp;raquo;/b/nobr/a/font/div/font/td/tr/table
|
|
Sailors, Marines Return From Record Deployment Military.com - Jan 01, 1970
table border=0 cellpadding=2 cellspacing=7 style=vertical-align:top;trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNHxfAPsFsJSEcTNoPrzSY7dYK5GSgamp;url=http://abclocal.go.com/wtvd/story?section%3Dnews/local%26id%3D8531652img src=//nt1.ggpht.com/news/tbn/8fI7V5zi1MqCDM/6.jpg alt= border=1 width=80 height=80 /br /font size=-2abc11.com/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbr /div style=padding-top:0.8em;img alt= height=1 width=1 //divdiv class=lha href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNFo5WbUmjHKfyf6q8Fp6zMahacJ5gamp;url=http://www.military.com/news/article/marine-corps-news/sailors-marines-return-rom-record-deployment.htmlbSailors, Marines Return From Record Deployment/b/abr /font size=-1bfont color=#6f6f6fMilitary.com/font/b/fontbr /font size=-1MOREHEAD CITY, NC -- Sailors and Marines from the 22nd Marine Expeditionary Unit (MEU) aboard amphibious dock landing bship/b USS Whidbey Island (LSD 41) returned to the United States following a 10 1/2-month deployment when the bship/b pulled into Morehead b/b/fontbr /font size=-1a href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNFJwxSZzMW__4WwMR-vJFdA7FrUrQamp;url=http://www.dvidshub.net/news/83354/whidbey-island-22nd-meu-return-us-after-record-breaking-deploymentWhidbey Island, 22nd MEU return to U.S. after record-breaking deployment/afont size=-1 color=#6f6f6fnobrDVIDS/nobr/font/fontbr /font size=-1 class=p/fontbr /font class=p size=-1a class=p href=http://news.google.com/news/more?ncl=drn50llbwQ-vPcMtNpCmL9y3xGWoMamp;ned=usnobrball 39 news articlesnbsp;raquo;/b/nobr/a/font/div/font/td/tr/table
|
|
Ship of the Future to Battle Pirates Discovery News - Jan 01, 1970
table border=0 cellpadding=2 cellspacing=7 style=vertical-align:top;trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serif/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbr /div style=padding-top:0.8em;img alt= height=1 width=1 //divdiv class=lha href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNGTKh0if0OHxXptW-M1jDjCrIcJTwamp;url=http://news.discovery.com/tech/ship-future-battle-pirates-120130.htmlbbShip/b of the Future to Battle Pirates/b/abr /font size=-1bfont color=#6f6f6fDiscovery News/font/b/fontbr /font size=-1The project was presented Thursday and Friday in Nantes in western France to some 400 delegates attending MARISK, a forum on bshipping security/b. A series of traps and non-lethal defenses are set to be installed on board the Partisan, a French military b/b/fontbr /font size=-1 class=p/fontbr /font class=p size=-1a class=p href=http://news.google.com/news/more?ncl=dD21ks9MAgPY4qMamp;ned=usnobrband morenbsp;raquo;/b/nobr/a/font/div/font/td/tr/table
|
|
Horror cruise ship smash Herald Sun - Jan 01, 1970
table border=0 cellpadding=2 cellspacing=7 style=vertical-align:top;trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNEgQ6q_Jw5x1eVvtwRfdsGN9LuVigamp;url=http://www.theglobeandmail.com/news/world/cruise-ship-captain-admits-to-navigational-error/article2307524/img src=//nt1.ggpht.com/news/tbn/FXsNoaLCqa0TNM/6.jpg alt= border=1 width=80 height=80 /br /font size=-2Globe and Mail/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbr /div style=padding-top:0.8em;img alt= height=1 width=1 //divdiv class=lha href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNGzhS1duVslIpY1P62o0kKn3Mrzdgamp;url=http://www.heraldsun.com.au/ipad/horror-cruise-ship-smash/story-fn6s850w-1226244563663bHorror cruise bship/b smash/b/abr /font size=-1bfont color=#6f6f6fHerald Sun/font/b/fontbr /font size=-1quot;There are three certified dead,quot; Giuseppe Linardi, the top public bsecurity/b official in Grosseto near the Tuscany coast, told Italian media, explaining that difficulties in the rescue had led to confusion over the death toll which was put at six b/b/fontbr /font size=-1a href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNEBfBmMyANeqXo34k2jNDtsmxhHbQamp;url=http://sfluxe.com/2012/01/15/italy-ship-captain-arrested-following-deadly-cruise-accident/Italy: bShip/b captain arrested following deadly cruise accident/afont size=-1 color=#6f6f6fnobrSan Francisco Luxury News/nobr/font/fontbr /font size=-1a href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNFfC3BAosbBV5hk7wo36VKhU6fvWgamp;url=http://news.discovery.com/human/cruise-ship-italy-sinks-tuscany-120114.htmlCruise Liner Keels Over Off Tuscany Coast/afont size=-1 color=#6f6f6fnobrDiscovery News/nobr/font/fontbr /font size=-1a href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNEgc6MeYBbaccOx4k3dycNxOpsWRAamp;url=http://timesofindia.indiatimes.com/world/europe/Cruise-company-criticises-captain-as-death-toll-hits-five/articleshow/11506569.cmsCruise company criticises captain as death toll hits five/afont size=-1 color=#6f6f6fnobrTimes of India/nobr/font/fontbr /font size=-1 class=pa href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNFn50UgNHRbWXN75GmynO2H4L62Fgamp;url=http://www.dailytimes.com.pk/default.asp?page%3D2012%255C01%255C15%255Cstory_15-1-2012_pg4_3nobrPakistan Daily Times/nobr/a/fontbr /font class=p size=-1a class=p href=http://news.google.com/news/more?ncl=de4tiobvpMyCRYMOOrW-4Mji5bmJMamp;ned=usnobrball 17,996 news articlesnbsp;raquo;/b/nobr/a/font/div/font/td/tr/table
|
|
National EAS Test Considered a Success Despite Issues Emergency Management - Jan 01, 1970
table border=0 cellpadding=2 cellspacing=7 style=vertical-align:top;trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serif/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbr /div style=padding-top:0.8em;img alt= height=1 width=1 //divdiv class=lha href=http://news.google.com/news/url?sa=tamp;fd=Ramp;usg=AFQjCNHjL-9sHLSNhsQNJqdg2dBekUOnTAamp;url=http://www.emergencymgmt.com/training/National-EAS-Test-Considered-Success.htmlbNational EAS Test Considered a Success Despite Issues/b/abr /font size=-1bfont color=#6f6f6fEmergency Management/font/b/fontbr /font size=-1The bship/b is 115 ft wide fromquot; With the first national test of the Emergency bAlert System/b (EAS) declared a success, federal officials and EAS participants are hoping that local emergency managers and public safety officials will become more engaged in b/b/fontbr /font size=-1 class=p/fontbr /font class=p size=-1a class=p href=http://news.google.com/news/more?ncl=dgI6cO71Clww2eMamp;ned=usnobrband morenbsp;raquo;/b/nobr/a/font/div/font/td/tr/table
|
|
|