<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:georss="http://www.georss.org/georss" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:media="http://search.yahoo.com/mrss/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Dylan's BI Study Notes</title>
	
	<link>http://dylanwan.wordpress.com</link>
	<description>My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management</description>
	<lastBuildDate>Wed, 15 May 2013 00:09:32 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.com/</generator>
<cloud domain="dylanwan.wordpress.com" port="80" path="/?rsscloud=notify" registerProcedure="" protocol="http-post" />
<image>
		<url>http://s2.wp.com/i/buttonw-com.png</url>
		<title>Dylan's BI Study Notes</title>
		<link>http://dylanwan.wordpress.com</link>
	</image>
	<atom:link rel="search" type="application/opensearchdescription+xml" href="http://dylanwan.wordpress.com/osd.xml" title="Dylan's BI Study Notes" />
	
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/DylanBI" /><feedburner:info uri="dylanbi" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://dylanwan.wordpress.com/?pushpress=hub" /><item>
		<title>Using Load Plan for managing your ETL task in BI Apps 11.1.1.7.1 (1)</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/3Yic2j7yZH4/</link>
		<comments>http://dylanwan.wordpress.com/2013/05/14/using-load-plan-for-managing-your-etl-task-in-bi-apps-11-1-1-7-1-1/#comments</comments>
		<pubDate>Tue, 14 May 2013 23:35:46 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI Application]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[DAC]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[Infomatica]]></category>
		<category><![CDATA[OBIA]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>
		<category><![CDATA[Load Plan]]></category>
		<category><![CDATA[LPG]]></category>
		<category><![CDATA[Oracle Load Plan]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=724</guid>
		<description><![CDATA[One of the major change introduced in BI Apps 11.1.1.7.1 is the way how we manage the ETL task sequence and trim the unnecessary tasks. This functionality was accomplished earlier using DAC.  The problem we frequently faced was that the DAC repository and the INFA repository are maintained as two separate repositories.  We have to sync up the name [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=724&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/05/14/using-load-plan-for-managing-your-etl-task-in-bi-apps-11-1-1-7-1-1/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/05/14/using-load-plan-for-managing-your-etl-task-in-bi-apps-11-1-1-7-1-1/</feedburner:origLink></item>
		<item>
		<title>Incremental ETL in BI Apps 11.1.1.7.1 (1)</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/dOizBJR5SuU/</link>
		<comments>http://dylanwan.wordpress.com/2013/05/10/incremental-etl-in-bi-apps-11-1-1-7-1-1/#comments</comments>
		<pubDate>Sat, 11 May 2013 01:18:37 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Application]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>
		<category><![CDATA[BIAPPS]]></category>
		<category><![CDATA[OBIA]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=715</guid>
		<description><![CDATA[The data warehouse needs to be refreshed periodically to make sure that the data warehouse have the up to date information.  The Incremental Load is the regular ETL process running everyday.  The frequency can vary, but it is commonly seen as nightly job.  To ensure that the incremental ETL job can be finished within a [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=715&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/05/10/incremental-etl-in-bi-apps-11-1-1-7-1-1/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/05/10/incremental-etl-in-bi-apps-11-1-1-7-1-1/</feedburner:origLink></item>
		<item>
		<title>BI Apps 11.1.1.7.1 (BI Apps in ODI) is available in OTN</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/WphAuQKBSTI/</link>
		<comments>http://dylanwan.wordpress.com/2013/05/06/bi-apps-11-1-1-7-1-bi-apps-in-odi-is-available-in-otn/#comments</comments>
		<pubDate>Mon, 06 May 2013 20:44:58 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=703</guid>
		<description><![CDATA[First Go to OTN www.oracle.com/technetwork Go to DOWNLOADS -&#62; Middleware You will see Business Intelligence Applications under Middleware You see both 10g and 11g.  Click on Oracle Business Intelligence 11g downloads You will see BI Apps 11.1.1.7.1 here: Oracle Business Intelligence Applications (11.1.1.7.1)  <img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=703&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/05/06/bi-apps-11-1-1-7-1-bi-apps-in-odi-is-available-in-otn/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/05/06/bi-apps-11-1-1-7-1-bi-apps-in-odi-is-available-in-otn/</feedburner:origLink></item>
		<item>
		<title>Benefits of using ODI as the ETL for BI Apps</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/8XO_qNm-7bI/</link>
		<comments>http://dylanwan.wordpress.com/2013/05/02/benefits-of-using-odi-as-the-etl-for-bi-apps/#comments</comments>
		<pubDate>Fri, 03 May 2013 00:19:40 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[BI]]></category>
		<category><![CDATA[DAC]]></category>
		<category><![CDATA[GoldenGate]]></category>
		<category><![CDATA[OBIA]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[ODI KM]]></category>
		<category><![CDATA[ODI SDK]]></category>
		<category><![CDATA[ODI UDF]]></category>
		<category><![CDATA[Oracle Load Plan]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=657</guid>
		<description><![CDATA[Oracle Data Integrator is being used as the ETL tool for BI Apps.  Here are some benefits: 1. Productivity It tasks less efforts for developers to write a ETL map comparing  to other ETL tool. 2. Define ETL flow patterns in KM The reason why now we can take less effort is that the flow [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=657&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/05/02/benefits-of-using-odi-as-the-etl-for-bi-apps/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/05/02/benefits-of-using-odi-as-the-etl-for-bi-apps/</feedburner:origLink></item>
		<item>
		<title>BI Application development team is hiring</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/bq9kJb7ZsCA/</link>
		<comments>http://dylanwan.wordpress.com/2013/02/26/bi-application-development-team-is-hiring/#comments</comments>
		<pubDate>Tue, 26 Feb 2013 08:29:54 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=655</guid>
		<description><![CDATA[BI Application development team is hiring They are hiring a senior application engineer.  The job requires experienced ETL and BI developers with 3- 7 year experience.  <img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=655&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/02/26/bi-application-development-team-is-hiring/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/02/26/bi-application-development-team-is-hiring/</feedburner:origLink></item>
		<item>
		<title>Why use GoldenGate in ETL?</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/pjmYIm1NAoo/</link>
		<comments>http://dylanwan.wordpress.com/2013/02/15/why-use-goldengate-in-etl/#comments</comments>
		<pubDate>Fri, 15 Feb 2013 18:46:41 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[GlodenGate]]></category>
		<category><![CDATA[OBIA]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=631</guid>
		<description><![CDATA[The traditional way of doing ETL nightly is no longer satisfying the requirements.  In the past, we have the ETL &#8220;window&#8221;  to perform ETL.  The ETL processes typically run as daily or nightly ETL.  We can use the downtime to execute some processes in the OLTP systems to extract their data while we can still [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=631&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2013/02/15/why-use-goldengate-in-etl/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2013/02/15/why-use-goldengate-in-etl/</feedburner:origLink></item>
		<item>
		<title>Extending your BI using Fusion Application Composer</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/_9kDDpntMmY/</link>
		<comments>http://dylanwan.wordpress.com/2012/12/12/extending-your-bi-using-fusion-application-composer/#comments</comments>
		<pubDate>Wed, 12 Dec 2012 19:30:41 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Application]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[OBIEE]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle BI Suite EE]]></category>
		<category><![CDATA[OTBI]]></category>
		<category><![CDATA[BI APps]]></category>
		<category><![CDATA[BIEE]]></category>
		<category><![CDATA[Extensibility]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=572</guid>
		<description><![CDATA[This is a very cool feature I have not seen for years. We have heard the demands of customizing the reports from customers for years.  The deploying company almost always wants to create some custom reports.  One of the selling point of the Oracle BI platform and Oracle BI Apps has been how easy it [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=572&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/12/12/extending-your-bi-using-fusion-application-composer/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/12/12/extending-your-bi-using-fusion-application-composer/</feedburner:origLink></item>
		<item>
		<title>ODI Shortcut</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/XFHO-tTkMos/</link>
		<comments>http://dylanwan.wordpress.com/2012/05/25/odi-shortcut/#comments</comments>
		<pubDate>Fri, 25 May 2012 18:45:03 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>
		<category><![CDATA[OWB]]></category>
		<category><![CDATA[Sunopsis]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=480</guid>
		<description><![CDATA[ODI provides the shortcut feature since the 11.1.1.6.0 release.  Shortcuts look like symbolic links in Linux file system and shortcuts in windows. You keep a reference to an object that exists in another folder. The symbolic link feature has been used widely in prepackaged apps development to handle multiple releases of the software product internally. [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=480&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/05/25/odi-shortcut/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/05/25/odi-shortcut/</feedburner:origLink></item>
		<item>
		<title>Use ODI SDK in Groovy</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/MBYblvZ4ANE/</link>
		<comments>http://dylanwan.wordpress.com/2012/05/12/use-odi-sdk-in-groovy-15/#comments</comments>
		<pubDate>Sun, 13 May 2012 04:52:24 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Groovy]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[ODI SDK]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=537</guid>
		<description><![CDATA[ODI 11.1.1.5 includes a built-in Groovy editor in the ODI studio. If you run the groovy script within ODI studio, it automatically run against the ODI repository you are connecting to. You can do a lot of the tasks that you do in ODI studio in ODI SDK. I tried to use ODI SDK to [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=537&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/05/12/use-odi-sdk-in-groovy-15/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/05/12/use-odi-sdk-in-groovy-15/</feedburner:origLink></item>
		<item>
		<title>About Big Data (2): SQL and No SQL</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/5r0nGpBScqk/</link>
		<comments>http://dylanwan.wordpress.com/2012/04/14/about-big-data-2-sql-and-no-sql/#comments</comments>
		<pubDate>Sun, 15 Apr 2012 06:35:36 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Big Data]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[Hive]]></category>
		<category><![CDATA[Pig]]></category>
		<category><![CDATA[Pig Latin]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/2012/04/14/about-big-data-2-sql-and-no-sql/</guid>
		<description><![CDATA[This is a good article written by Alan Gates, Pig architect at Yahoo! Comparing Pig Latin and SQL for Constructing Data Processing Pipelines He compares Pig Latin, a query language for Hive with SQL, the query language for relational database. He gave a good example that helps those who know SQL to understand the differences. The query [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=449&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/04/14/about-big-data-2-sql-and-no-sql/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/04/14/about-big-data-2-sql-and-no-sql/</feedburner:origLink></item>
		<item>
		<title>Tutorial: Create ODI Repositories</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/eifSOozx6vw/</link>
		<comments>http://dylanwan.wordpress.com/2012/04/14/tutorial-create-odi-repositories/#comments</comments>
		<pubDate>Sat, 14 Apr 2012 19:18:23 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/2012/04/14/tutorial-create-odi-repositories/</guid>
		<description><![CDATA[This step is not required if you are working on an existing repository.  If you are doing a new development project, or just want to get some experiences on using ODI, you may need to create ODI repositories yourselves. A typical ODI deployment includes two repositories: Master Repository and Work Repository. ODI provides two different [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=429&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/04/14/tutorial-create-odi-repositories/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/04/14/tutorial-create-odi-repositories/</feedburner:origLink></item>
		<item>
		<title>ODI Topology</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/B1PP-o_xO0w/</link>
		<comments>http://dylanwan.wordpress.com/2012/04/13/odi-topology/#comments</comments>
		<pubDate>Sat, 14 Apr 2012 03:41:50 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/2012/04/13/odi-topology/</guid>
		<description><![CDATA[ODI has a very clever design to isolate the deployment objects from design objects. The designer only interface to deployment information (topology) via logical schema.  The project objects only indirectly get the dependency via model.  The &#8220;context&#8221; can determine the physical resources and allow you switch among the development, testing and production env. From prebuilt [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=407&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/04/13/odi-topology/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/04/13/odi-topology/</feedburner:origLink></item>
		<item>
		<title>About Big Data (1)</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/AzC4CxTb8oU/</link>
		<comments>http://dylanwan.wordpress.com/2012/03/07/about-big-data-1/#comments</comments>
		<pubDate>Wed, 07 Mar 2012 19:06:00 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Big Data]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[big-data]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/2012/03/07/about-big-data-1/</guid>
		<description><![CDATA[Recently I read several articles and books about big data. I found that many use a very funny definition to define big data. Big data is the data that you typically cannot handle in the database.  It is bigger than the size of the data you have. What? It is a joke I told my [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=389&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2012/03/07/about-big-data-1/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2012/03/07/about-big-data-1/</feedburner:origLink></item>
		<item>
		<title>Dimension Hierarchy Support in Data Warehouse(2)</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/w7MzKRYEoMw/</link>
		<comments>http://dylanwan.wordpress.com/2011/12/08/dimension-hierarchy-support-in-data-warehouse2/#comments</comments>
		<pubDate>Thu, 08 Dec 2011 18:48:35 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=372</guid>
		<description><![CDATA[I am describing the column flattening table in this post. The column flattening table is a typical data warehouse modeling pattern for addressing the dimension hierarchy requirements described in my last post Dimension Hierarchy Support in Data Warehouse (1). This technique can be considered as a denormalization of the parent information into the child records. [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=372&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/12/08/dimension-hierarchy-support-in-data-warehouse2/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/12/08/dimension-hierarchy-support-in-data-warehouse2/</feedburner:origLink></item>
		<item>
		<title>OTBI vs. OBIA</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/2OH9MRHkySE/</link>
		<comments>http://dylanwan.wordpress.com/2011/10/05/otbi-vs-obia/#comments</comments>
		<pubDate>Thu, 06 Oct 2011 00:34:48 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Application]]></category>
		<category><![CDATA[BI Links]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[DBI]]></category>
		<category><![CDATA[essbase]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[Infomatica]]></category>
		<category><![CDATA[OBIA]]></category>
		<category><![CDATA[OBIEE]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle BI Suite EE]]></category>
		<category><![CDATA[OTBI]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=369</guid>
		<description><![CDATA[Several people are curious about what are OTBI and OBIA, and what are the differences between OTBI and OBIA.  I will discuss these in this article. OTBI stands for Oracle Transactional Buisness Intelligence.  OBIA stands for Oracle Business Intelligence Applications. Let&#8217;s start with OBIA.  OBIA is the pre-packaged BI Apps that Oracle has provided for [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=369&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/10/05/otbi-vs-obia/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/10/05/otbi-vs-obia/</feedburner:origLink></item>
		<item>
		<title>Dimension Hierarchy Support in Data Warehouse (1)</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/je2rgGWCIxs/</link>
		<comments>http://dylanwan.wordpress.com/2011/06/07/dimension-hierarchy-support-in-the-data-warehouse-1/#comments</comments>
		<pubDate>Wed, 08 Jun 2011 07:04:05 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Work]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[OBIA]]></category>
		<category><![CDATA[OBIEE]]></category>
		<category><![CDATA[Oracle BI Suite EE]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=363</guid>
		<description><![CDATA[This is my first post about dimension hierarchy support in a data warehouse. I will first starting with the requirement assumptions in this post and later posts will talk about the implementations. Dimension is mainly about &#8220;View By&#8221;,  &#8220;Group by&#8221;, and &#8220;Filter By&#8221;.  You say that you want to view your last year sales by [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=363&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/06/07/dimension-hierarchy-support-in-the-data-warehouse-1/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/06/07/dimension-hierarchy-support-in-the-data-warehouse-1/</feedburner:origLink></item>
		<item>
		<title>BI Apps 7.9.6.3 is out</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/5zMxhrwGM5Q/</link>
		<comments>http://dylanwan.wordpress.com/2011/05/20/bi-apps-7-9-6-3-is-out/#comments</comments>
		<pubDate>Fri, 20 May 2011 16:48:48 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=351</guid>
		<description><![CDATA[You can use BI EE 11.1.1.5.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=351&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/05/20/bi-apps-7-9-6-3-is-out/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/05/20/bi-apps-7-9-6-3-is-out/</feedburner:origLink></item>
		<item>
		<title>Oracle To Acquire Datanomic</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/KtxjlJU1fYg/</link>
		<comments>http://dylanwan.wordpress.com/2011/04/15/oracle-to-acquire-datanomic/#comments</comments>
		<pubDate>Fri, 15 Apr 2011 22:55:11 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[Business Intelligence]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=348</guid>
		<description><![CDATA[http://www.oracle.com/us/corporate/Acquisitions/datanomic/index.html<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=348&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/04/15/oracle-to-acquire-datanomic/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/04/15/oracle-to-acquire-datanomic/</feedburner:origLink></item>
		<item>
		<title>User Defined Function (UDF) in ODI</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/LyDdfDeyQmg/</link>
		<comments>http://dylanwan.wordpress.com/2011/03/21/user-defined-function-udf-in-odi/#comments</comments>
		<pubDate>Mon, 21 Mar 2011 16:37:29 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Application]]></category>
		<category><![CDATA[BI Work]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[Infomatica]]></category>
		<category><![CDATA[OBIA]]></category>
		<category><![CDATA[ODI]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Data Integrator]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=340</guid>
		<description><![CDATA[User Defined Function (UDF) is a very powerful feature from ODI. One of features that are absent from other ETL tool is to address the need to support different database platforms.  I won&#8217;t blame those ETL tools since they are not really designed for pre-package BI Apps. Who will need to switch database platform like [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=340&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/03/21/user-defined-function-udf-in-odi/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/03/21/user-defined-function-udf-in-odi/</feedburner:origLink></item>
		<item>
		<title>Why I do not use PowerConnect to access PeopleSoft Tree</title>
		<link>http://feedproxy.google.com/~r/DylanBI/~3/k_QrGuuz1Eg/</link>
		<comments>http://dylanwan.wordpress.com/2011/03/16/why-i-do-not-use-powerconnect-to-access-peoplesoft-tree/#comments</comments>
		<pubDate>Thu, 17 Mar 2011 01:56:39 +0000</pubDate>
		<dc:creator>Dylan Wan</dc:creator>
				<category><![CDATA[BI]]></category>
		<category><![CDATA[BI Application]]></category>
		<category><![CDATA[Business Intelligence]]></category>
		<category><![CDATA[Data Warehouse]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[Infomatica]]></category>
		<category><![CDATA[OBIEE]]></category>
		<category><![CDATA[PeopleSoft]]></category>

		<guid isPermaLink="false">http://dylanwan.wordpress.com/?p=335</guid>
		<description><![CDATA[1. It does not allow you to use parameters to the PeopleSoft connect. It may be changed later. However, it was a big issue when we try to address customer issues. 2. It requires EFFDT as an input. It expects that people change the EFFDT using Mapping Editor. How can a business user does that [&#8230;]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dylanwan.wordpress.com&#038;blog=437134&#038;post=335&#038;subd=dylanwan&#038;ref=&#038;feed=1" width="1" height="1" />]]></description>
		<wfw:commentRss>http://dylanwan.wordpress.com/2011/03/16/why-i-do-not-use-powerconnect-to-access-peoplesoft-tree/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://2.gravatar.com/avatar/51fb8164bbddc3b7be4680455fa40630?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">Dylan</media:title>
		</media:content>
	<feedburner:origLink>http://dylanwan.wordpress.com/2011/03/16/why-i-do-not-use-powerconnect-to-access-peoplesoft-tree/</feedburner:origLink></item>
	</channel>
</rss>
