tag:blogger.com,1999:blog-66386341910637474002024-03-28T17:56:07.876+05:30Oracle Business IntelligenceOBIEE Interview Questions, OBIEE Tutorial or Training, Informatica Interview questions, Informatica Tutorial or Training, Datawarehouse DWH Interview Questions, Oracle Interview questions
UPCOMING: Informatica Video Tutorials and OBIEE Video TutorialsAnonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.comBlogger92125tag:blogger.com,1999:blog-6638634191063747400.post-60979088099641470792013-03-25T22:36:00.002+05:302013-04-12T17:05:35.373+05:30Cache Management<div dir="ltr" style="text-align: left;" trbidi="on">
Cache Management in OBIEE<br />
<br />
<br />
1. Admin tool Manage > Cache > Purge<br />
<br />
You can purge all the cache or cache by Subject Area or Cache by query<br />
<br />
<br />
2. Physical Layer<br />
<br />
Physical Table Properties > Cacheable, Cache persistence time<br />
<br />
<br />
3 Event Pooling Table<br />
<br />
<br />
4. EM(Enterprise Manager) > Capacity Management >Performance > Cache Enabled<br />
<br />
<br />
5. Analysis > Advanced tab > Bypass presentation cache<br />
<br />
<br />
6. Analysis > Advanced tab ><br />
<br />
Prefix set variable DISABLE_CACHE_HIT=1;<br />
<br />
<br />
7. When dynamic variable value changes the cache associated with that subject area purges<br />
<br />
8.. Creating a batch file and scheduling it<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com375tag:blogger.com,1999:blog-6638634191063747400.post-4355102436143681112013-02-01T19:06:00.000+05:302013-02-01T19:06:52.977+05:30XML Source Qualifier Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about XML Source Qualifier Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">XML Source Qualifier transformation is a passive transformation which allows you to read the data from XML files</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Every XML source definition is by default associated with XML Source Qualifier transformation</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiDGzlwmgVb4dzotRfnxKRriBMIHVSocKU3LECGLUCPO_-IQjF9F-mdAUg8jp1GeaquU_PXuNOPkyCU2e73v6M7_m7EIsKI1OUHQF4wVPbCzf6FFmBrIBxi04HiSRgWExNzWlFGfAqnDgp/s1600/XML.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiDGzlwmgVb4dzotRfnxKRriBMIHVSocKU3LECGLUCPO_-IQjF9F-mdAUg8jp1GeaquU_PXuNOPkyCU2e73v6M7_m7EIsKI1OUHQF4wVPbCzf6FFmBrIBxi04HiSRgWExNzWlFGfAqnDgp/s640/XML.png" width="640" /></a></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com11tag:blogger.com,1999:blog-6638634191063747400.post-85890599515310868262013-02-01T18:41:00.000+05:302013-02-01T18:45:13.657+05:30Transaction Control Transformation <div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-family: Georgia, Times New Roman, serif;">Explain about Transaction Control Transformation </span></b><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b>
</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Transaction Control transformation is an active transformation which allows you to control the transactions which are bounded by "<i>commit</i>" and "<i>rollback</i>" transaction control operations</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">The powercenter supports 2 different ways to control the transactions</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">The conditional Transaction Control expression can be developed using Transaction Control transformation at mapping level</span><span style="font-family: Georgia, Times New Roman, serif;"><br /></span><span style="font-family: Georgia, Times New Roman, serif;">A commit interval is the number of rows at which an integration service applies commit to the target </span><span style="font-family: Georgia, Times New Roman, serif;"><br /></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">1. Using Transaction Control transformation at mapping level</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. Using <u><i>commit interval</i></u> property at session level</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">IFF(SAL>3000, commit, rollback)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">In Properties tab</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;">Enter the transaction control expression in the Transaction Control Condition field. The transaction control expression uses the IIF function to test each row against the condition. Use the following syntax for the expression:</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">IIF (condition, value1, value2)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The expression contains values that represent actions the Integration Service performs based on the return value of the condition. The Integration Service evaluates the condition on a row-by-row basis. The return value determines whether the Integration Service commits, rolls back, or makes no transaction changes to the row. When the Integration Service issues a commit or roll back based on the return value of the expression, it begins a new transaction. Use the following built-in variables in the Expression Editor when you create a transaction control expression:</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><i>TC_CONTINUE_TRANSACTION.</i> The Integration Service does not perform any transaction change for this row. This is the default value of the expression. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><i>TC_COMMIT_BEFORE</i>. The Integration Service commits the transaction, begins a new transaction, and writes the current row to the target. The current row is in the new transaction. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><i>TC_COMMIT_AFTER</i>. The Integration Service writes the current row to the target, commits the transaction, and begins a new transaction. The current row is in the committed transaction. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><i>TC_ROLLBACK_BEFORE</i>. The Integration Service rolls back the current transaction, begins a new transaction, and writes the current row to the target. The current row is in the new transaction. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><i>TC_ROLLBACK_AFTER</i>. The Integration Service writes the current row to the target, rolls back the transaction, and begins a new transaction. The current row is in the rolled back transaction. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">If the transaction control expression evaluates to a value other than commit, roll back, or continue, the Integration Service fails the session.</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">This property can be set at session level</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">The default commit interval is "10000"</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBg_uu5oRhSMWXahOOIFoBsTwkuR7Ka-S8bM_25HdGxz_zcEvPya5Iof2qP7eFpUPwv7PF3BhghylsPk4OkKcFMQshzKQLxzzbgFJGH3N5dkXWNXsDWDfXXl-OeNOtruPe8ew74aKoQQAB/s1600/TC.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBg_uu5oRhSMWXahOOIFoBsTwkuR7Ka-S8bM_25HdGxz_zcEvPya5Iof2qP7eFpUPwv7PF3BhghylsPk4OkKcFMQshzKQLxzzbgFJGH3N5dkXWNXsDWDfXXl-OeNOtruPe8ew74aKoQQAB/s640/TC.png" width="640" /></a></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com9tag:blogger.com,1999:blog-6638634191063747400.post-51516341042907408112013-02-01T16:14:00.000+05:302013-02-01T18:36:52.999+05:30Union Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Union Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Union Transformation is an active transformation which combine the data record s vertically from multiple sources having same metadata</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">The Union transformation also supports heterogeneous joins</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Heterogeneous join Ex: Emp(Oracle) + Employee (SQL Server)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Union Transformation is created with two groups</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">1. <u>Input Group</u>: It can receive the data from source pipeline</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. <u>Output Group</u>: It provides the data for further processing or loading</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">All the input and output groups should have matching ports. The precision, datatype and scale should be same for all the groups</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Union Transformation functions as "UNION ALL" operator in SQL</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">UNION ALL allows duplicates</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotEaYbkJYmSvKBHmkZK_vTYDC2eWniStvvdtWLGdhcFkhLL8tvAsKK_C_gJ8Mi7UCi3f_TkMBE8XjCbZXVnK3ZehvssDCeT58kvPIVsQOPFwso1LiabGytySZtdqyYnzF-04E__W9ZKVU/s1600/Union.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotEaYbkJYmSvKBHmkZK_vTYDC2eWniStvvdtWLGdhcFkhLL8tvAsKK_C_gJ8Mi7UCi3f_TkMBE8XjCbZXVnK3ZehvssDCeT58kvPIVsQOPFwso1LiabGytySZtdqyYnzF-04E__W9ZKVU/s640/Union.png" width="640" /></a></div>
<br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Differences between Sorter and Union Transformation</span><br />
<a href="http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html"><span style="font-family: Georgia, Times New Roman, serif;">http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html</span></a><br />
<i><span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></i>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com3tag:blogger.com,1999:blog-6638634191063747400.post-83324383776152051362013-02-01T12:10:00.001+05:302013-02-01T12:56:52.049+05:30Difference between Joiner and Union Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<ul style="text-align: left;">
<li>Joiner Transformation can join only two input groups whereas Union Transformation can join multiple input groups</li>
<li>Joiner Transformation combines the records horizontally based on the join condition whereas Union Transformation joins the records vertically</li>
<li>Joiner Transformation supports Normal join, Master outer join, Detail outer join and Full outer join whereas Union Transformation does UNION ALL</li>
<li>Joiner Transformation removes duplicates whereas Union Transformation doesn't </li>
</ul>
<div>
Both these transformation supports heterogeneous joins(Join between two different data sources Ex: Oracle + SQLServer)</div>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com2tag:blogger.com,1999:blog-6638634191063747400.post-21061758728255300382013-02-01T10:29:00.000+05:302013-02-01T16:47:48.088+05:30Joiner Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Joiner Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Joiner Transformation is an active transformation which allows you to combine the data records horizontally based on join condition i.e.., you need a matching column to join the data.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Joiner transformation combines the data from two different sources having different metadata</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">A </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation is created with following types of ports</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1. Input port (I)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. Output port (O)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">3. Master port (M)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">A </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation <i style="text-decoration: underline;">can only join two input data stream</i> per joiner</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">The sources to the </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation designated as "<i>Master source</i>" and "<i>Detailed source</i>"</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">If you have more than one source, you need to connected output of a joiner to another input pipeline.</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWCA0EAZQdTYzJ78UgBjimd9_IxoB45SvxIyhyphenhyphenrv5Ay68K0rb89p_JdW0aMS-VuGEBHmLcH6u1AP7DwqK-cgKG-UvbcIslLylv-KiWonECuRbKIExOPMSZZNYJW0WOCBzAqR_x_ZT3FBJM/s1600/JOINER.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWCA0EAZQdTYzJ78UgBjimd9_IxoB45SvxIyhyphenhyphenrv5Ay68K0rb89p_JdW0aMS-VuGEBHmLcH6u1AP7DwqK-cgKG-UvbcIslLylv-KiWonECuRbKIExOPMSZZNYJW0WOCBzAqR_x_ZT3FBJM/s640/JOINER.png" width="640" /></a></div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">A source which is having the lesser number of records is designated as "<i>master source</i>" and the other source is designated as "<i>detailed source</i>"</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">A Master source is the source which occupies least amount of space or memory in cache</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation supports homogeneous and heterogeneous joins</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">A join which is made on same data source is known as homogeneous join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ex: Oracle + Oracle or SQL server + SQL server</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<br />
<span style="font-family: Georgia, 'Times New Roman', serif;">A join which is made on different data sources is known as heterogeneous join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ex: Oracle + SQL server</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">The </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation is created with the following types of joins</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">1. Normal Join (equi join or inner join)</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">2. Master outer join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">3. Detail outer join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">4. Full outer join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">The default join type is Normal join</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">Consider the following data</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">EMP1 - MASTER SOURCE</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><b>NAME DEPTNO CITY </b> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 London </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Antony 20 Chicago</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ram 30 Hyderabad</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">EMP2 - DETAIL SOURCE</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><b>NAME DEPTNO AGE</b></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 42</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Ram 30 28</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Garry 40 39</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>NORMAL JOIN</u> </span><br />
<b style="font-family: Georgia, 'Times New Roman', serif;">NAME DEPTNO CITY AGE </b><span style="font-family: Georgia, 'Times New Roman', serif;"> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 London 42</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ram 30 Hyderabad 28</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>MASTER OUTER JOIN</u></span><br />
<b style="font-family: Georgia, 'Times New Roman', serif;">NAME DEPTNO CITY AGE </b><span style="font-family: Georgia, 'Times New Roman', serif;"> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 London 42</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ram 30 Hyderabad 28</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Garry 40 NULL 39</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><u>DETAILED OUTER JOIN</u></span><br />
<b style="font-family: Georgia, 'Times New Roman', serif;">NAME DEPTNO CITY AGE </b><span style="font-family: Georgia, 'Times New Roman', serif;"> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 London 42</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Antony 20 Chicago NULL</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ram 30 Hyderabad 28</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><u>FULL OUTER JOIN</u></span><br />
<b style="font-family: Georgia, 'Times New Roman', serif;">NAME DEPTNO CITY AGE </b><span style="font-family: Georgia, 'Times New Roman', serif;"> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Mark 10 London 42</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Antony 20 Chicago NULL</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Ram 30 Hyderabad 28</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Garry 40 NULL 39</span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOKV-eAKfo3DkvJLQalZoBhqCf3iPIDiY83vzDImFpIBVehE-4D3MVo56weI1z34QHyWplKGMdVWYBdcQv9g46aaBycZvi7Tkw-LYoFxPrrzOJEDoBghlztKRbEvNW_z14XOZj3RucK7PO/s1600/JOINER.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="238" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOKV-eAKfo3DkvJLQalZoBhqCf3iPIDiY83vzDImFpIBVehE-4D3MVo56weI1z34QHyWplKGMdVWYBdcQv9g46aaBycZvi7Tkw-LYoFxPrrzOJEDoBghlztKRbEvNW_z14XOZj3RucK7PO/s640/JOINER.png" width="640" /></a></div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<br />
<span style="font-family: Georgia, 'Times New Roman', serif;">When you run a session with a Joiner transformation, the Integration Service blocks and unblocks the source data, based on the mapping configuration and whether you configure the Joiner transformation for sorted input.</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><i>Unsorted Joiner Transformation</i></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">When the Integration Service processes an unsorted Joiner transformation, it reads all master rows before it reads the detail rows. To ensure it reads all master rows before the detail rows, the Integration Service blocks the detail source while it caches rows from the master source. Once the Integration Service reads and caches all master rows, it unblocks the detail source and reads the detail rows. Some mappings with unsorted Joiner transformations violate data flow validation.</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><i>Sorted Joiner Transformation</i></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">When the Integration Service processes a sorted Joiner transformation, it blocks data based on the mapping configuration. Blocking logic is possible if master and detail input to the Joiner transformation originate from different sources. </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">The Integration Service uses blocking logic to process the Joiner transformation if it can do so without blocking all sources in a target load order group simultaneously. Otherwise, it does not use blocking logic. Instead, it stores more rows in the cache.</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">When the Integration Service can use blocking logic to process the Joiner transformation, it stores fewer rows in the cache, increasing performance.</span><br />
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<i><span style="font-family: Georgia, 'Times New Roman', serif;">The </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation doesn't support non-equijoin</span></i><br />
<i><span style="font-family: Georgia, 'Times New Roman', serif;">The </span><span style="font-family: Georgia, 'Times New Roman', serif;">Joiner transformation supports only "AND" operator</span></i><br />
<span style="font-family: Georgia, Times New Roman, serif;"><i>You cannot use a Joiner transformation when both the input pipelines contains an Update Strategy transformation. </i></span><br />
<i style="font-family: Georgia, 'Times New Roman', serif;">You cannot use a Joiner transformation if you connect a Sequence Generator transformation directly before the Joiner transformation. </i><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Differences between Sorter and Union Transformation</span><br />
<a href="http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html"><span style="font-family: Georgia, Times New Roman, serif;">http://prashanthobiee.blogspot.in/2013/02/difference-between-joiner-and-union.html</span></a><br />
<i><span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></i>
<i><span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></i>
<i><span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></i>
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com3tag:blogger.com,1999:blog-6638634191063747400.post-25283386938046661062013-01-18T16:13:00.002+05:302013-01-18T16:13:50.950+05:30Ragged and Skipped Hierarchy<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">OBIEE 11g supports Ragged and Skipped hierarchies. Let see what they actually are</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>Ragged Hierarchy</u>: A Ragged hierarchy is a hierarchy which has unbalanced child attributes</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">In the example below C1 doesn't have a child(level D)attribute while C2 has child attributes(level D). It is unbalanced</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>Skipped Hierarchy</u>: A Skipped hierarchy is a hierarchy in which some child doesn't have a direct parent attribute i.e., some attributes missing at some level.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">In the example below D3 and D4 has direct parent attribute(level C) while D5 doesn't have a direct parent attribute(level C). Level C is skipped for the child D5</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI_-nW1PKyF6WabN3DWmGkVbtYV861fa_FHDBdKHFFcYooCkVZ3MoT1-ZY5mcFMMN6iTBVSwfh4M7rjEzHIQ33MTlNuhxblCS0UstRLi9XJbBe9VPD7PYzfZOp_U9pC6l8MbwSXq7KfLwd/s1600/Hierar.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI_-nW1PKyF6WabN3DWmGkVbtYV861fa_FHDBdKHFFcYooCkVZ3MoT1-ZY5mcFMMN6iTBVSwfh4M7rjEzHIQ33MTlNuhxblCS0UstRLi9XJbBe9VPD7PYzfZOp_U9pC6l8MbwSXq7KfLwd/s640/Hierar.png" width="640" /></a></div>
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">To know what a hierarchy is check this</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://prashanthobiee.blogspot.in/2013/01/hierarchy.html">http://prashanthobiee.blogspot.in/2013/01/hierarchy.html</a></span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com36tag:blogger.com,1999:blog-6638634191063747400.post-954490631547754312013-01-18T15:29:00.001+05:302013-01-18T16:14:45.633+05:30Hierarchy<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<br /></div>
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<span style="font-family: Georgia, Times New Roman, serif;">A Hierarchy is set of parent-child relationship between certain attributes of a dimension. </span></div>
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<span style="font-family: Georgia, Times New Roman, serif;">An example gives you a clear idea what an hierarchy is</span></div>
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmuUeRPr0kZt9XCLvi0UKjnir0MI39OgGzY6YgzbFJaM0ndoGSHmcyl7BH9anTB0ccHxvPfiyT6yqK6vnsq_wfWoHeO650LCNNSazKkSfivvek05O-EYb4HMRGTTTWlLcJQET__tVeuxjm/s1600/hierarchy.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmuUeRPr0kZt9XCLvi0UKjnir0MI39OgGzY6YgzbFJaM0ndoGSHmcyl7BH9anTB0ccHxvPfiyT6yqK6vnsq_wfWoHeO650LCNNSazKkSfivvek05O-EYb4HMRGTTTWlLcJQET__tVeuxjm/s400/hierarchy.png" width="281" /></a></div>
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div style="background-color: white; margin-bottom: 1em; padding: 0px; text-align: justify;">
<span style="font-family: Georgia, Times New Roman, serif;">To know about Ragged and Skipped hierarchies check this</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><a href="http://prashanthobiee.blogspot.in/2013/01/ragged-and-skipped-hierarchy.html">http://prashanthobiee.blogspot.in/2013/01/ragged-and-skipped-hierarchy.html</a></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-36196377085419155762013-01-15T17:12:00.000+05:302013-01-15T17:21:38.008+05:30OBIEE Architecture<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">OBIEE Architecture and how it works for easy understanding</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">For Beginners this would give you a clear idea how OBIEE works</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJadjvcLZ_ihfDJGZmHcjnpJdZrxpCKIZAKCdGJvNjoHfh0FsspVUUXHxky-o6wpAhpIa8SLhLGw2V0lhYGulWBrQLDFEiiNWv4OoAitGJZvhrLxW_UsiFc23vCufulplb9H9wpuLvhX7G/s1600/OBIEE.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif;"><img border="0" height="174" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJadjvcLZ_ihfDJGZmHcjnpJdZrxpCKIZAKCdGJvNjoHfh0FsspVUUXHxky-o6wpAhpIa8SLhLGw2V0lhYGulWBrQLDFEiiNWv4OoAitGJZvhrLxW_UsiFc23vCufulplb9H9wpuLvhX7G/s640/OBIEE.png" width="640" /></span></a></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">A request is made by the Users through Answers and sent to the Presentation server. The Presentation Server converts the request into logical SQL and sent to the BI server. The BI server converts logical SQL into physical SQL and sent it to the database. The result get back to the user through the same path </span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com5tag:blogger.com,1999:blog-6638634191063747400.post-23088194061779642412013-01-08T22:14:00.001+05:302013-01-08T22:14:57.594+05:30Source Qualifier Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Source Qualifier transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Source Qualifier transformation is an active transformation which read or extract the data from the database and flat files</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">SQ can be used to</span><br />
<br />
<ul style="text-align: left;">
<li><span style="font-family: Georgia, Times New Roman, serif;">Join tables from same data sources</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">filter the rows when the Integration service (it adds a WHERE clause to the query) reads the data from the data source</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">specify the sorted ports. The Integration service adds a ORDER BY clause to the query with sorted ports</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">select distinct values from the source. t</span><span style="font-family: Georgia, 'Times New Roman', serif;">he Integration service adds a SELECT DISTINCT clause to the query </span></li>
</ul>
<br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><u>SQL override</u>: It is a process of changing the default SQL generated by Source Qualifier transformation</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>Source Filter</u>: If the source is a database the Informatica recommends to use source filter condition rather than using filter transformation. It improves performance of data extraction</span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-36499688267395823952013-01-03T17:22:00.001+05:302013-01-03T17:23:49.414+05:30Available Oracle BI Apps<div dir="ltr" style="text-align: left;" trbidi="on">
<table border="0" cellpadding="0" cellspacing="0" style="background-color: white; color: #666666; line-height: 20.383333206176758px; text-align: start; width: 668px;"><tbody>
<tr><td valign="top" width="98%"><div style="background-color: transparent; border: 0px; font-size: 12px; margin-bottom: 15px; outline: 0px; padding: 0px 0px 0px 30px;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;"><span style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;"><br />The following are currently available with Oracle BI Apps</span></span></div>
<div style="background-color: transparent; border: 0px; font-size: 12px; margin-bottom: 15px; outline: 0px; padding: 0px 0px 0px 30px;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;"><br /></strong></span></div>
<div style="background-color: transparent; border: 0px; font-size: 12px; margin-bottom: 15px; outline: 0px; padding: 0px 0px 0px 30px;">
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;">ERP Analytics</strong></span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;"> </strong>- Oracle Financial Analytics<br />- Oracle Procurement and Spend Analytics<br />- Oracle Human Resources Analytics<br />- Oracle Supply Chain and Order Management Analytics<br />- Oracle Spend Classification Analytics<br />- Oracle Project Analytics<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;"><br />CRM Analytics</strong></span><br />
<span style="font-family: Georgia, Times New Roman, serif; font-size: small;">- Oracle Sales Analytics<br />- Oracle Service Analytics<br />- Oracle Marketing Analytics<br />- Oracle Contact Center Analytics<br />- Oracle Loyalty Analytics<br />- Oracle Price Analytics<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px;"><br />Industry Applications</strong></span><br />
<strong style="background-color: transparent; border: 0px; font-family: Georgia, 'Times New Roman', serif; font-size: medium; line-height: 20.383333206176758px; margin: 0px; outline: 0px; padding: 0px;">-</strong><span style="background-color: transparent; font-family: Georgia, 'Times New Roman', serif; font-size: small; line-height: 20.383333206176758px;"> Oracle US Federal Financial Analytics</span></div>
<div style="background-color: transparent; border: 0px; font-size: 12px; margin-bottom: 15px; outline: 0px; padding: 0px 0px 0px 30px;">
<span style="background-color: transparent; font-family: Georgia, 'Times New Roman', serif; font-size: small; line-height: 20.383333206176758px;"><br /></span></div>
<div style="background-color: transparent; border: 0px; font-size: 12px; margin-bottom: 15px; outline: 0px; padding: 0px 0px 0px 30px;">
<span style="background-color: transparent; font-family: Georgia, 'Times New Roman', serif; font-size: small; line-height: 20.383333206176758px;"><br /></span></div>
</td></tr>
</tbody></table>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-20819279710949334982013-01-03T17:17:00.003+05:302013-01-03T17:17:37.598+05:30Components of Oracle BI Apps<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Components of Oracle BI Apps</b><br />
<b><br /></b>
The main components of Oracle BI Apps are:<br />
<br />
1. ETL tool Informatica or ODI (SDE, SIL and PLP)<br />
2. DAC repository<br />
3. OBAW (pre-built)<br />
4. RPD<br />
5. Web Catalog</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com8tag:blogger.com,1999:blog-6638634191063747400.post-18986418845430106972013-01-03T17:14:00.000+05:302013-01-03T17:14:08.315+05:30OBIA<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;">OBIA stands for Oracle Business Intelligence Apps. OBIA is a pre-built end to end BI Application. It consists of pre-built mappings, repository, reports, Dashboards, etc</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Current version of OBIA is 7.9.6.3 and is compatible with Informatica 9.x, DAC 10g and OBIEE 11g</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">OBIA has pre-built adapters for Oracle Apps(EBS), JDEdwards, Siebel and Peoplesoft. <span style="background-color: white; color: #666666; line-height: 20.383333206176758px;">In additional to these pre-built adapters Oracle provides the Universal adapters that enable any other source system to be a source for the Datawarehouse.</span></span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com3tag:blogger.com,1999:blog-6638634191063747400.post-77361455271695588622013-01-03T15:38:00.001+05:302013-01-03T15:38:35.878+05:30MUDE<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: 11.4pt; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: #333333;"><span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about MUDE</b></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 11.4pt; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: #333333;"><span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 11.4pt; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: #333333;"><span style="font-family: Georgia, Times New Roman, serif;">MUDE (Multi-user development environment) is used for multi-user development of the repository. </span></span></div>
<div class="MsoNormal" style="background: white; line-height: 11.4pt; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: #333333;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 11.4pt; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: #333333;"><span style="font-family: Georgia, Times New Roman, serif;">Create a shared directory on the network for Multi-user
Development (MUD).<br />
Open the RPD to use in MUD. From Tools->Options, setup the MUD directory to
point to the above directory.<br />
Define projects within the RPD to allow multiple users to develop within their
subject area or Facts.<br />
Save and move the RPD to the shared directory setup in point 1.<br />
When users work in the MUD mode, they open the admin tool and start with<br />
MUD ->Checkout to check out the project they need to work on (not use the
File open as you would usually do).<br />
After completely the development, user checking the changes back to the network
and merge the changes.</span></span><span style="color: #333333; font-family: "Georgia","serif"; font-size: 8.5pt; mso-bidi-font-family: Helvetica; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-80017189068121407232012-12-27T19:08:00.001+05:302012-12-27T19:08:29.099+05:30Informatica Client tools<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">The Power Center Client consists of the following applications that we use to manage the repository, design mappings, mapplets, and create sessions to load the data:</span></div>
<ol>
<li><span style="font-family: Georgia, Times New Roman, serif;">Designer</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Data Stencil</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Repository Manager</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Workflow Manager</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;">Workflow Monitor</span></li>
</ol>
<div style="margin-bottom: 12px;">
<strong><span style="font-family: Georgia, Times New Roman, serif;">1. Designer:</span></strong></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">Use the Designer to create mappings that contain transformation instructions for the Integration Service.</span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">The Designer has the following tools that you use to analyze sources, design target Schemas, and build source-to-target mappings:</span></div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;"> <u>Source Analyzer</u>: Import or create source definitions.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u><b> </b>Target Designer</u><b>: </b>Import or create target definitions.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"> <u>Transformation Developer</u><b>:</b> Develop transformations to use in mappings.</span></li>
</ul>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">You can also develop user-defined functions to use in expressions.</span></div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;"> <u>Mapplet Designer</u>: Create sets of transformations to use in mappings.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"> <u>Mapping Designer</u><b>:</b><b> </b>Create mappings that the Integration Service uses to Extract, transform, and load data.</span></li>
</ul>
<div style="margin-bottom: 12px;">
</div>
<div style="margin-bottom: 12px;">
<strong><span style="font-family: Georgia, Times New Roman, serif;">2.Data Stencil</span></strong></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">Use the Data Stencil to create mapping template that can be used to generate multiple mappings. Data Stencil uses the Microsoft Office Visio interface to create mapping templates. Not used by a developer usually.</span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;"><strong>3.Repository Manager</strong></span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">Use the Repository Manager to administer repositories. You can navigate through multiple folders and repositories, and complete the following tasks:</span></div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Manage users and groups</u><b>:</b> Create, edit, and delete repository users and User groups. We can assign and revoke repository privileges and folder Permissions.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Perform folder functions</u>: Create, edit, copy, and delete folders. Work we perform in the Designer and Workflow Manager is stored in folders. If we want to share metadata, you can configure a folder to be shared.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>View metadata</u><strong>: </strong>Analyze sources, targets, mappings, and shortcut dependencies, search by keyword, and view the properties of repository Objects. We create repository objects using the Designer and Workflow Manager Client tools.</span></li>
</ul>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">We can view the following objects in the Navigator window of the Repository Manager:</span></div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Source definitions:</u> Definitions of database objects (tables, views, synonyms) or Files that provide source data.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Target definitions:</u> Definitions of database objects or files that contain the target data.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Mappings:</u> A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Integration Service uses to transform and move data.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Reusable transformations:</u> Transformations that we use in multiple mappings.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Mapplets:</u> A set of transformations that you use in multiple mappings.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Sessions and workflows:</u> Sessions and workflows store information about how and When the Integration Service moves data. A workflow is a set of instructions that Describes how and when to run tasks related to extracting, transforming, and loading Data. A session is a type of task that you can put in a workflow. Each session Corresponds to a single mapping.</span></li>
</ul>
<div style="margin-bottom: 12px;">
<strong><span style="font-family: Georgia, Times New Roman, serif;">4.Workflow Manager :</span></strong></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">Use the Workflow Manager to create, schedule, and run workflows. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.</span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">The Workflow Manager has the following tools to help us develop a workflow:</span></div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Task Developer:</u> Create tasks we want to accomplish in the workflow.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Worklet Designer</u>: Create a worklet in the Worklet Designer. A worklet is an object that groups a set of tasks. A worklet is similar to a workflow, but without scheduling information. We can nest worklets inside a workflow.</span></li>
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Workflow Designer</u><b>:</b> Create a workflow by connecting tasks with links in the Workflow Designer. You can also create tasks in the Workflow Designer as you develop the workflow.</span></li>
</ul>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">When we create a workflow in the Workflow Designer, we add tasks to the workflow. The Workflow Manager includes tasks, such as the Session task, the Command task, and the Email task so you can design a workflow. The Session task is based on a mapping we build in the Designer.</span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">We then connect tasks with links to specify the order of execution for the tasks we created. Use conditional links and workflow variables to create branches in the workflow.</span></div>
<div style="margin-bottom: 12px;">
<strong><span style="font-family: Georgia, Times New Roman, serif;">5.Workflow Monitor</span></strong></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">Use the Workflow Monitor to monitor scheduled and running workflows for each Integration Service. We can view details about a workflow or task in Gantt chart view or Task view. We Can run, stop, abort, and resume workflows from the Workflow Monitor. We can view Sessions and workflow log events in the Workflow Monitor Log Viewer.</span></div>
<div style="margin-bottom: 12px;">
<span style="font-family: Georgia, Times New Roman, serif;">The Workflow Monitor displays workflows that have run at least once. The Workflow Monitor continuously receives information from the Integration Service and Repository Service. It also fetches information from the repository to display historic Information.</span></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /><br />Source: <a href="http://informaticatutorials-naveen.blogspot.com/2011/04/powercenter-client.html#ixzz2GG7lNfXx" style="text-decoration: initial;">http://informaticatutorials-naveen.blogspot.com/2011/04/powercenter-client.html#ixzz2GG7lNfXx</a> </span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com2tag:blogger.com,1999:blog-6638634191063747400.post-56751851372370341212012-12-27T18:52:00.000+05:302013-01-04T22:42:59.339+05:30Exercise to implement Router Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Using Scott schema</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b>Design a mapping to pass the correct data to one target and the exception data to another target (NULL Validation)</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">EMP------->SQ_EMP------> Router ------> Emp_Correct and Emp_Exception</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b> </b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;"><u>DETAILED DESCRIPTION</u>:</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">will update shortly</span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com2tag:blogger.com,1999:blog-6638634191063747400.post-21653289921052688652012-12-27T18:36:00.003+05:302012-12-27T19:12:09.885+05:30Exercise to implement Filter, Rank and Expression Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Complete this when you finish reading Filter, Rank and Expression transformation</b><br />
<b>Using Scott schema</b><br />
<b>Calculate the <i>Tax</i>(14% of SAL) for top 3 employees based on salary who belongs to Sales department and Sales department ID is 30. </b><br />
<b>Create Target_Emp which contains the following columns EmpNO, Ename, Job, Sal, Tax and Deptno</b><br />
<b><br /></b>
<b><br /></b>
EMP -----> SQ_EMP ---------> DEPTNO=30--------> Tax= SAL*0.14------> Target_Emp<br />
<br />
EMP ----> SQ_EMP ------> DEPTNO=30-----> Top3(SAL)----> Tax= SAL*0.14-----> Target_Emp<br />
Filter T/F Rank T/F Expression T/F <br />
<br />
<br />
<br />
<u>PROCEDURE</u><br />
<u><br /></u>
Will update shortly</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com1tag:blogger.com,1999:blog-6638634191063747400.post-7335273107494810112012-12-27T17:31:00.002+05:302012-12-27T19:12:09.907+05:30Normalizer Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Normalizer Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Normalizer transformation is an active transformation which allows you to read data from "<i>cobol files"</i></span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Every<i> cobol </i>source definition by default associate with </span><span style="font-family: Georgia, 'Times New Roman', serif;">Normalizer transformation </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">Use the </span><span style="font-family: Georgia, 'Times New Roman', serif;">Normalizer transformation to convert a single input record into multiple output records. </span><span style="font-family: Georgia, 'Times New Roman', serif;">This is known as "<i>Horizontal pivot</i>"</span><br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-46430298897899772972012-12-27T17:07:00.001+05:302012-12-27T19:12:09.894+05:30Stored Procedure Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Stored Procedure Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Stored Procedure transformation is a passive transformation which is used to import Stored Procedure from database</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">A </span><span style="font-family: Georgia, 'Times New Roman', serif;">Stored Procedure should exist in the database before using the </span><span style="font-family: Georgia, Times New Roman, serif;">Stored Procedure in the mapping</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Set the following properties to define Stored Procedure transformation</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">1. <u>Normal</u>: This the default property set for the Stored Procedure transformation, it allows you to pass record by record to mapping during session execution</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">2. <u>Source preload</u>: A stored procedure executes before session reads the data from the source</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">3. <u>Source postload</u>: </span><span style="font-family: Georgia, 'Times New Roman', serif;">A stored procedure executes after session reads the data from the source</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">4. <u>Target preload</u> : </span><span style="font-family: Georgia, 'Times New Roman', serif;">A stored procedure executes before session loads the data into the target</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">5</span><span style="font-family: Georgia, 'Times New Roman', serif;">. <u>Target postload</u> : </span><span style="font-family: Georgia, 'Times New Roman', serif;">A stored procedure executes after session loads the data into the target</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">There are two types of stored procedures</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">1. Connected Stored procedure</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">2. Unc</span><span style="font-family: Georgia, 'Times New Roman', serif;">onnected Stored procedure</span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com27tag:blogger.com,1999:blog-6638634191063747400.post-90036419728369292722012-12-27T16:09:00.000+05:302012-12-27T19:12:09.918+05:30Update Strategy Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Update Strategy Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Update Strategy Transformation is an active transformation which flags the source records for insert, update, delete and reject data driven operations</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">An Update Strategy Transformation functions as DML commands in SQL</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">An Update Strategy Transformation operates on target database account. The target table require a primary key to update the record</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Informatica Powercenter allows you to implement an Update Strategy Transformation in two ways</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">1. Using Update Strategy transformation at mapping level</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. Using target table properties at session level</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The conditional Update Strategy expressions can be developed by using an Update Strategy transformation with following constants</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">DD_INSERT -----> 0</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">DD_UPDATE </span><span style="font-family: Georgia, 'Times New Roman', serif;">-----> 1</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">DD_DELETE </span><span style="font-family: Georgia, 'Times New Roman', serif;">-----> 2</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">DD_REJECT </span><span style="font-family: Georgia, 'Times New Roman', serif;">-----> 3</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;"><u>Conditional Expression</u></span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span>
<span style="font-family: Georgia, 'Times New Roman', serif;">IFF(SAL>2000, DD_INSERT, DD_UPDATE)</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"> (or)</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">IFF(SAL>2000, 0,1)</span><br />
<br />
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">The default update strategy expression is "DD_INSERT"</span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">Use the following target table properties at session level to implement an update strategy</span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">1. <u>INSERT</u>: It inserts the record in the target</span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">2. <u>UPDATE AS UPDATE</u></span><span style="font-family: Georgia, 'Times New Roman', serif;">: It updates the record in the target</span><span style="font-family: Georgia, 'Times New Roman', serif;"> </span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">3. </span><u style="font-family: Georgia, 'Times New Roman', serif;">DELETE</u><span style="font-family: Georgia, 'Times New Roman', serif;">: It deletes the record from the target</span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">4. <u>UPDATE AS </u></span><u style="font-family: Georgia, 'Times New Roman', serif;">INSERT</u><span style="font-family: Georgia, 'Times New Roman', serif;">: For each update in the source it inserts a new record in the target</span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, 'Times New Roman', serif;">5. <u>UPDATE ELSE INSERT</u></span><span style="font-family: Georgia, 'Times New Roman', serif;">: It updates the record if it exist in the target else inserts the record in the target</span></div>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com1tag:blogger.com,1999:blog-6638634191063747400.post-39977732437332353362012-12-27T13:14:00.000+05:302012-12-27T19:12:09.891+05:30Sequence Generator Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Sequence Generator Transformation.</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b></span>
<span style="font-family: Georgia, Times New Roman, serif;">Sequence Generator Transformation is a passive transformation which allows you to generate sequence numbers which are to be treated as primary keys </span><br />
<span style="font-family: Georgia, Times New Roman, serif;">A <a href="http://prashanthobiee.blogspot.in/2012/12/surrogate-key_25.html" target="_blank">Surrogate key</a> is a system generated sequence number which are used as dimensional keys or artificial keys or synthetic keys </span><br />
<span style="font-family: Georgia, Times New Roman, serif;">A Sequence Generator Transformation is created with default output ports</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1. NEXTVAL (generates a sequence of numbers by connecting it to a transformation or target</span><span style="font-family: Georgia, 'Times New Roman', serif;">)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. CURRVAL (is the NEXTVAL value plus one or NEXTVAL plus the increment by value.</span><span style="font-family: Georgia, 'Times New Roman', serif;">)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">This transformation doesn't allow you to create new ports or edit the existing ports</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Set the following properties to generate sequence numbers</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1. Start Value (zero)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. Current Value (one)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">3. Increment by (one)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0tag:blogger.com,1999:blog-6638634191063747400.post-10312654500956670932012-12-27T11:51:00.001+05:302012-12-27T13:02:19.997+05:30OBIEE Components<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">For Beginners let me give a clear picture how this tool works</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: left;">
</div>
<div class="MsoNormal">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;">OLTP DATABASE ------> ETL --------> OLAP DATABASE -------> OBIEE</span></span></div>
<div class="MsoNormal">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;">In OBIEE</span></span></div>
<div class="MsoNormal">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;">RPD ----------> BI server --------> Presentation Server -------> Reports/Dashboards</span></span></div>
<div class="MsoNormal">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Components of
OBIEE : <o:p></o:p></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><b>OBIEE </b>can be divided into 3 parts</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">i. Repository or Administration Tools</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">ii. Reports/ Dashboards</span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">iii. </span><span style="line-height: 21.81818199157715px;">Ibots/Agents(11g)/Delivers</span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="line-height: 21.81818199157715px;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<span style="font-family: Georgia, Times New Roman, serif;">
</span><br />
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">OBIEE
has two types of components</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%; text-indent: -0.25in;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%; text-indent: -0.25in;">1.<span style="line-height: normal;">
</span></span><span style="line-height: 150%; text-indent: -0.25in;">Server Component</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%; text-indent: -0.25in;">2.<span style="line-height: normal;">
</span></span><span style="line-height: 150%; text-indent: -0.25in;">Client Component</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%; text-indent: -0.25in;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<ol start="1" style="margin-top: 0in;" type="1">
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Server
Components :<o:p></o:p></span></span></li>
<ol start="1" style="margin-top: 0in;" type="a">
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Oracle BI
Server (can be considered as heart for OBIEE)<o:p></o:p></span></span></li>
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Oracle
Presentation Server<o:p></o:p></span></span></li>
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Application
Server<o:p></o:p></span></span></li>
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Scheduler<o:p></o:p></span></span></li>
<li class="MsoNormal" style="line-height: 150%; text-align: left;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Cluster
Controller</span></span></li>
</ol>
</ol>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;"><b>Oracle BI Server: </b>It</span><span style="line-height: 150%;"> is a core engine acts as a heart of entire OBIEE
software which performs following operations. It controls/coordinates all
reporting/repository building operations by communicating/coordinating with
other server components. It takes the logical SQL requests from Presentation
server and generates the optimized queries against the report request. These
queries are send to physical database for execution. It manages cache to
redirect queries to cache /purge cache ..etc. It is also responsible for
security implementation, online repository building, Multi user development..etc.
following are the other components which BI server controls/coordinates.</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><span style="line-height: 150%;"><i>Repository</i>:</span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"> Repository is a meta data of physical data warehouse structures which were
converted to Logical dimensional structures. Presentation Layer of the
repository contains the objects which needed to exposed to users for report
generation. This repository stores in a file with extension .rpd.</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-indent: 0px;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%; text-indent: -0.25in;"><span style="line-height: 150%;"><i>NQSConfig:</i></span></span><span style="line-height: 150%; text-indent: -0.25in;"> This file is key configuration file from where OBIEE
server reads the initial parameters information before it starts. It is by
default located at x:\OracleBI\server\Config(for 10g) and x</span><span style="background-color: #f2f2f2;">\</span>Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository</span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">(for 11g). In 11g you can change the repository using EM</span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><span style="line-height: 150%;"><i>Log files:</i></span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"> All
the log files are placed by default at x:\OracleBI\server\Log(For 10g) and in 11g you can directly find them from EM</span><br />
<div style="text-indent: -24px;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 24.545454025268555px;">I</span></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><span style="line-height: normal;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><i>NQCluster</i>:</span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><span style="line-height: normal;"> </span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Logs OBIEE clustering
information if it is configured as cluster.</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><i>NQQuery</i>:</span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><span style="line-height: normal;"> </span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Records all the step
by step process of each and every report/query activity in OBIEE. We can see
all physical and logical queries in this log.</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;"><i>Logical query</i></span><span style="line-height: 150%;"> can be understood only by OBIEE server. These
queries are generated based on the reports/answers criteria which executed from
OBIEE presentation services.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Example;<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.5in; text-align: left; text-indent: 0.5in;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT PROD_NAME from PRODUCTS saw_0 <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.5in; text-align: left; text-indent: 0.5in;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">FROM "Sales1" ORDER BY
saw_0<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.5in; text-align: left; text-indent: 0.5in;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;"><i>Physical Query</i></span><span style="line-height: 150%;"><i>:</i> OBIEE server will convert logical queries to
database specific physical queries which can be executed on DW database.
Logical queries are converted to physical queries based on logical/physical
model metadata definitions in repository file.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">A repository is a collection of data definitions.
Or data about data (Metadata).<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%;"><i>Cache: </i></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%;">Caching is a process of storing the Info on
separate layer after fetching data from physical warehouse. This helps to reuse
the Information which is frequently going queried by users without hitting the
database for every request.</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Presentation
Server:</span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%;">Presentation service is a Single application that
provides Oracle BI Answers, Dashboards, delivers etc via web browsers.</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">·<span style="line-height: normal;">
</span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Take the request form
the client tools and pars the request to OBIEE server.</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">·<span style="line-height: normal;">
</span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Since presentation
services are service components, in order to work on presentation services it
requires a <b>application server</b>.</span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 1.25in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">·<span style="line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 150%;"> </span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Application
Server:</span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Application Server is the server which provides
the 3-tier Architecture features and helps to work on web based client
components and by default oracle provides oc4j(10g) application server along with
OBIEE s/w. These can be changed in case organization wants to go with diff app.
Servers like IIs or web sphere. OBIEE provides a default application server by
name OC4J. In the real production servers we can replace this by any other </span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%; text-indent: 0.5in;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">OBIEE 11g uses weblogic server</span></span></span><br />
<span style="line-height: 150%; text-indent: 0.5in;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b style="line-height: 150%; text-indent: 0.5in;"><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">OBI Scheduler:</span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Is
a server component helps to schedule a job. To install and configure BI
Scheduler requires a relational repository. We need to create a empty user and
configure to BI scheduler. While creating repository OBIEE will create required
tables in this user. It stores all schedule related information. For running
iBots this components is mandatory. The jobs which are schedule by BI Scheduler
can be monitored by job manager.<o:p></o:p></span></span><br />
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">iBots are known as Agents in 11g</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<br /></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Client
Components : </span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">OBIEE has two types of client components</span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">·<span style="line-height: normal;">
</span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Browser (Web )based
client</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">·<span style="line-height: normal;">
</span></span><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 150%; text-indent: -0.25in;">Non web based client</span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<b><span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Non web based
client components : <o:p></o:p></span></span></b></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;"> <b>OBIEE Administration</b> tool is used
to build a repositories (metadata model)
on top of physical data ware house It contains three layers.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 1.25in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">·<span style="line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 150%;">Physical layer<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 1.25in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">·<span style="line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 150%;">Business layer<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.5in; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Presentation This helps to easily navigate unix
folder structures via graphical interface.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.5in; text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="line-height: 150%;">ODBC Client:</span></b><span style="line-height: 150%;"> allows to connect to a database and execute SQL
commands. Mostly BIEE testers will use this tool to test the
repository/reports. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; text-align: left;">
<span style="line-height: 150%;"><span style="font-family: Georgia, Times New Roman, serif;">Browser based Clients : These tools will wok only
on any internet browser. Following the tool.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">1.<span style="font-weight: normal; line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">Interactive Dashboards : </span></b><span style="line-height: 150%;">Dashboard is a logical container of components
developed by OBIEE like answers, other web pages, other dashboards. This
provides additional features like prompts, guided navigation etc.<b><o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">2.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;"> Answers :</span></b><span style="line-height: 150%;"> Oracle BI Answers also called as reports provides
a highly Interactive user interfaces to generate reports/analytics with complex
calculations and multiple views and filters etc.s <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">3.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">Oracle Delivers : C</span></b><span style="line-height: 150%;">reate proactive alerts with the help of a engine
called iBots. It also helps to deliver
the contents in various formats to different. Destinations. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">4.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">Disconnected Analytics :</span></b><span style="line-height: 150%;"> Simulated online working environment even though
not connected to data ware housing. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">5.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">MS_Office Plugin :</span></b><span style="line-height: 150%;"> Integrates the OBIEE generated data with all
MS_Office product which can further analyzed on local desktop Office products.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">6.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">BI presentation Service Administration :</span></b><span style="line-height: 150%;"> Client component helps to admin the activities
which are being in progress within presentation services. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="line-height: 150%; margin-left: 0.75in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 150%;">7.<span style="line-height: normal;">
</span></span><!--[endif]--><b><span style="line-height: 150%;">BI Publisher :</span></b><span style="line-height: 150%;"> OBI publisher which was knows as XML publisher allows to create reports
based on the layouts created in MS word or Excel. The report output can be
published/bursted to various media and various people.<o:p></o:p></span></span></div>
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com13tag:blogger.com,1999:blog-6638634191063747400.post-81666682215311645662012-12-27T11:42:00.001+05:302012-12-27T19:12:09.908+05:30Lookup Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-family: Georgia, Times New Roman, serif;">Explain about Lookup Transformation</span></b><br />
<b><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></b>
<span style="font-family: Georgia, Times New Roman, serif;"><i>Lookup Transformation </i>is a passive transformation which allows you to perform look up on relational table, flat files, synonyms and views</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">When a mapping contains a Lookup Transformation the integration service queries the look up data and compares it with look up input port values</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Lookup Transformation is created with the following ports</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">1. Input port (I)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">2. Output port (O)</span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">3. Lookup port (L)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">4. Return port (R)</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Lookup Transformation supports horizontal merging such as equi-join and non equi-join</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">Use Lookup Transformation to perform following tasks</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"> Get a related value </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"> In updating <a href="http://prashanthobiee.blogspot.in/2012/11/slowly-changing-dimension.html" target="_blank">Slowly Changing Dimension (SCD)</a></span><br />
<br />
<br />
Connected and Unconnected Lookup will be discussed later<br />
<br />
<br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com16tag:blogger.com,1999:blog-6638634191063747400.post-46947390591752873292012-12-27T11:29:00.000+05:302013-01-16T14:20:30.868+05:30Aggregator Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Aggregator Transformation</b></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b>
</span></div>
<span style="font-family: Georgia, Times New Roman, serif;">Aggregator Transformation is an active Transformation which allows you to calculate the summary's for <u>group of records</u>. The Integration Service performs aggregate calculations as it reads and stores data group and row data in an aggregate cache</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Aggregate functions supported are </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif;">SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, VARIANCE, PERCENTILE and STDDEV</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"></span><br />
<br />
<br />
<span style="font-family: Georgia, 'Times New Roman', serif;">An Aggregator Transformation is created with following components</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"></span><br />
<ul style="text-align: left;">
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Group by</u>: This component defines the group for a specific port which participates in aggregation</span></li>
</ul>
<ul style="text-align: left;">
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Aggregator Expressions</u>: Use aggregate function to derive aggregate expressions which can be developed in either variable ports or only output ports</span></li>
</ul>
<ul style="text-align: left;">
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Aggregator cache</u>: An Integration service creates aggregate cache for "<i>unsorted inputs</i>". It stores the group value in <i>index cache </i>data in the <i>data cache</i></span></li>
</ul>
<ul style="text-align: left;">
<li><span style="font-family: Georgia, Times New Roman, serif;"><u>Sorted input</u>: "<i>Group by ports</i>" are sorted using a sorted transformation and receive the sorted data as input to improve the performance of data aggregation </span></li>
</ul>
<div>
<div style="font-family: 'Times New Roman';">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, 'Times New Roman', serif;">Keep the sorted transformation prior to Aggregator Transformation to perform sorting on </span><i style="font-family: Georgia, 'Times New Roman', serif;">group by</i><span style="font-family: Georgia, 'Times New Roman', serif;"> ports</span></span></div>
<div style="font-family: 'Times New Roman';">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div style="font-family: 'Times New Roman';">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, Times New Roman, serif;">The aggregate cache contains <i>group by</i> ports, <i>non-group by</i> input and output ports which contains Aggregate expressions</span></span></div>
<div style="font-family: 'Times New Roman';">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Georgia, Times New Roman, serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCLWiAb9Q_6D288Q973LWZ5WgIXmXSoXAbrn8_OqsxfQFuZBXqJA_UUkbTVZ6TekmI9l3To0zSvdjb4YK8H7H-0HFaRVGN_y6Za76t0GRUuXDNR-wOzkeV9HLdqlYSBcolN7_Vyokezqi1/s1600/Agg.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCLWiAb9Q_6D288Q973LWZ5WgIXmXSoXAbrn8_OqsxfQFuZBXqJA_UUkbTVZ6TekmI9l3To0zSvdjb4YK8H7H-0HFaRVGN_y6Za76t0GRUuXDNR-wOzkeV9HLdqlYSBcolN7_Vyokezqi1/s640/Agg.png" width="640" /></a></span></div>
<div style="font-family: 'Times New Roman';">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
</div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">After you create a session that includes an Aggregator transformation, you can enable the session option, Incremental Aggregation. When the Integration Service performs incremental aggregation, it passes new source data through the mapping and uses historical cache data to perform new aggregation calculations incrementally</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;">When you run a session which consist of Aggregate Transformation, the Integration service creates index cache and data cache in the memory. If it requires more space it uses the cache. The index and data cache can be configured in the session properties</span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="font-family: Georgia, Times New Roman, serif;"><i>A session with an Aggregator transformation with Sorted input doesn't use the cache.</i></span></div>
<br />
<br />
<div style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo0AxZQacdUP84u4DKAiNl6scID3jk_lBxJkCpGIGJUD6EhDJLgWIQCWYZurYZnOku-i8GJd6CkFKaaAacDhbdk3mCC4GqQBbdnUr_OM89qsyJrYIDjmoNVDAiDmv926694_0-A0ling_B/s1600/Agg_sess.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="426" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo0AxZQacdUP84u4DKAiNl6scID3jk_lBxJkCpGIGJUD6EhDJLgWIQCWYZurYZnOku-i8GJd6CkFKaaAacDhbdk3mCC4GqQBbdnUr_OM89qsyJrYIDjmoNVDAiDmv926694_0-A0ling_B/s640/Agg_sess.png" width="640" /></a></div>
<div style="text-align: left;">
<br /></div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com3tag:blogger.com,1999:blog-6638634191063747400.post-89438145269052515282012-12-27T11:06:00.001+05:302013-01-15T19:09:20.078+05:30Sorter Transformation<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, Times New Roman, serif;"><b>Explain about Sorter Transformation</b></span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><b><br /></b>
Sorter Transformation is an active and connected transformation. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">It is used to sorts the data either in ascending or descending order based on a specific key. The port which is used in sorting operation is known as "<i>Key</i>"</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br />
Sorter Transformation can also sort on case sensitivity, it is can also be used to eliminate duplicates, hence it is an Active Transformation. Sorter transformation can be used before the Aggregator transformation for sorting the input to aggregator transformation.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br />
The Sorter function as "order by" clause in SQL</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">You can specify multiple sort keys. When you specify multiple sort keys, the Integration service sorts in the order of the ports. The primary sort is on the first sort key from the top. </span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Let us see a small example</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf97GidcUrCEPmW9L2iPVcQFDHgpQcy2BTHbeSuZfexxaTgc_ICImLNfEUrG2IuMMGX446_HZfxd_8JHF3i-bthsK8FJfyVOjrRgcB2ikQOa5HeEa-zr-3o1AKLxa2GtuTdOrYHs6L0slg/s1600/Sorter.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, Times New Roman, serif;"><img border="0" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf97GidcUrCEPmW9L2iPVcQFDHgpQcy2BTHbeSuZfexxaTgc_ICImLNfEUrG2IuMMGX446_HZfxd_8JHF3i-bthsK8FJfyVOjrRgcB2ikQOa5HeEa-zr-3o1AKLxa2GtuTdOrYHs6L0slg/s640/Sorter.png" width="640" /></span></a></div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Consider the following input data</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">EMPNO ENAME SAL DEPTNO</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1001 MARK 5000 10</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1002 TOM 8000 40</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1003 HARRY 7000 10</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1004 MARK 6500 20</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1005 WILL 4000 20</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">The Integration service groups first by ENAME annd then by DEPTNO</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">After sorting the data</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br />
<span style="font-family: Georgia, Times New Roman, serif;">EMPNO ENAME SAL DEPTNO</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1003 HARRY 7000 10</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1004 MARK 6500 20</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1001 MARK 5000 10</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1002 TOM 8000 40</span><br />
<span style="font-family: Georgia, Times New Roman, serif;">1005 WILL 4000 20</span><br />
<br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">In the above example the data is first sorted by ENAME ascending and then by DEPTNO descending</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<br /></div>
Anonymoushttp://www.blogger.com/profile/05085564958486527378noreply@blogger.com0