*/Oracle Business Intelligence Application/*

<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=Text&widgetId
=Text2&action=editWidget&sectionId=adleft>
* Home <http://mkashu.blogspot.com>
* DATAWAREHOUSE
<http://mkashu.blogspot.in/search/label/Data%20Warehousing>
* ORACLE DATABASE
<http://mkashu.blogspot.in/search/label/Oracle%20Administrator>
* OBIEE <http://mkashu.blogspot.in/search/label/OBIEE%2010G>
o OBIEE 10G <http://mkashu.blogspot.in/search/label/OBIEE%2010G>
o OBIEE 11G <http://mkashu.blogspot.in/search/label/OBIEE%2011G>
* OBIA
<http://mkashu.blogspot.in/search/label/Oracle%20Business%20Intelligence%20A
pplication>
o OBIA IN WINDOWS <http://mkashu.blogspot.in/>
o OBIA IN LINUX <http://mkashu.blogspot.in/>
o OBIA IN UNIX <http://mkashu.blogspot.in/>
* INFORMATICA <http://mkashu.blogspot.in/search/label/Informatica>
* DAC
<http://mkashu.blogspot.in/search/label/DATA%20WAREHOUSE%20ADMINISTRATOR%20C
ONSOLE>
* CONTACT <http://mkashu.blogspot.in/2013/08/contact-me.html>
* Home <#>
* Features <http://#>
o Shortcodes <#>
o Slideshow <#>
o Wallpaper Ad <#>
o Full Width Page <#>
o Archives Page <#>
o Homepage Blog <#>
o No Leaderboard <#>
o Typography <#>
* Business <#>
* Entertainment <#>
o Blogs <http://#>
o Columnists <http://#>
+ Max Mag Staff <http://#>
* Sports <#>
o Blogs <http://#>
o Columnists <http://#>
* Fashion <#>
* Tech <#>
* Travel <#>
* Food <#>
All About Data Warehousing and Business Intelligence
<http://mkashu.blogspot.in/>
A blog where you can explore everything about Data
warehouse,Oracle,OBIA, OBIEE,Informatica,ODI,DAC and many more data
warehouse products and tools....
* Support Center <http://mkashu.blogspot.in/2013/08/contact-me.html>

Don't miss
* OBIA 7.9.6.3 Installation
<http://mkashu.blogspot.in/search/label/Oracle%20Business%20Intelligence%20A
pplication>Posted
125 days ago
* What is OBIEE?
<http://mkashu.blogspot.in/2013/08/what-is-obiee.html>Posted 1 days ago
* OBIEE 11G Architecture
<http://mkashu.blogspot.in/2013/07/obiee-11g-architecture-with-explanation.h
tml>Posted
10 days ago
* Why Data warehouse
<http://mkashu.blogspot.in/2013/07/why-data-warehousing.html>Posted
13 days ago
*
<https://www.facebook.com/pages/Mkashu/617234158288952>
*
<https://twitter.com/kashumm>
*
<http://www.pinterest.com/mkashu/>
*
<https://plus.google.com/100593951254781598380/posts>
*
<#>
*
<https://in.linkedin.com/pub/kashif-m/19/880/b9>
*
<http://feeds.feedburner.com/AllAboutDataWarehouseAndBusinessIntelligence>
*
Wednesday, 14 May 2014
Cache Management in OBIEE 11g
<http://mkashu.blogspot.in/2014/05/cache-management-in-obiee-11g.html>
-----------------------------------------------------------------------*Kashif M* <https://plus.google.com/100593951254781598380> on 13:22
-----------------------------------------------------------------------1)

In OBIEE we have two types of cache

1.

Oracle BI Presentation Server Cache

2.

Oracle Bi Server Cache

*1. **Oracle BI Presentation Server Cache *

1)
It is a temporary cache , it will be stored in below location
C:\OBI11g.6\instances\instance2\tmp\OracleBIPresentationServicesComponent\
coreapplication_obips1\sawrptcache
2)
3)

It will be unique per particular user and session

OBIEE we have two types of cache

*2. **Oracle BI Server Cache *

4)

In OBIEE 11g cache parameters are managed using EM.

5)

EM initially will change nqsocnfig.INI file.

6)
In Nqsconfig file enable = yes then cache is enabled else cache
is disabled.
7)

By default cache files will be stored in below path

8)
E:/bi11g/instances/instance1/bifoundation/oracleBIservercomponenets/coreapplic
ation-obis1/cache.
*Advantage of cache:*
1)

Less network traffic.

2)

Huge performance improvement.

*_Disadvantage of cache: _*
1)

There is a chance to get stale data.

2)

Hard disk memory is wasted.

3)

Maintenance of cache by admin.

*_Cache architecture:
_*
*__*
<http://2.bp.blogspot.com/-Z6pfrqH_zzQ/U3fDS5K5wTI/AAAAAAAAMME/X2EhS_D25aI/s1600
/gbgigbbd-706509.png>
Cache Management in OBIEE 11g

Report logical sql will be compared with cache database logical sqls, if

anything is matching then corresponding cache output will be shown to

the user else it will execute from the db.
*_Enabling cache:_*
1)
Open EM -->capacity management -->performance -->lock & edit
-->select cache enabled -->apply -->activate changes -->close -->restart
oracle BI server.
2)
Go to NQSconfig file & notice that enable =yes. Run any one
report & go to the cache location & observe a file is created.
3)
Open RPD in online mode -->go to manage -->cache -->observe all
the parameters.
4)
Sign out from analysis -->sign in as abell -->password: Admin123
-->run same above report in the RPD -->manage -->cache -->notice that
use count is updated
to 1.
*_Stale data:_*
Old data is called as stale data.
A report ran from DB & stored that result into cache & the DB is updated
with new values then we run the same above report we will get output
from cache that means old data -->to eliminate this problem we need to
do purging followed by seeding.
*_Purging:_*
Cleaning cache files is called as purging.
We have four types of purging.
1.
Manual.
2.
Persistency time.
3.
Event pooling table.

4. ODBC functions.
*_Manual:_*
After enabling cache -->run any one report. Then cache will be created
-->open RPD in online mode -->manage -->cache -->right click on the

entry -->click on purge -->ok close.

*_Persistency:_*
It is useful to purge cache based on fixed time. To provide this setting
we need to know accurately the table updated frequency.
*_Process:_*
Open RPD in online mode -->double click on D1_products -->go to general
tab -->select cache persistence time -->type 2 mins -->ok -->check in
-->save -->reload server metadata -->develop a report with specific
columns & notice that cache is created -->after 2 mins automatically
cache will be purged.
_Note:_we can control cache at table level in physical layer double
click on any table -->general tab enable/disable cache. Revert to
cacheable -->cache never expires.
*_Event pooling table:_*
*_Step1: creating event pooling table:_*
Login to DB as supplier2 user create table s-nq-ept as select * from
dev-bi plat form s-nq-ept.
Select * from s-nq-ept.
*_Step2: creating a triggers:_*
To monitor D1-products create (or) replace trigger
EVENT-TABLE-UPDATE-TRIGGER after insert or update or delete on
D1-products for each row.
Begin
Insert into s-nq-ept (update type, update-TS, table-name) values
(sysdate,D1-products);
End;
/
Confirm trigger is working or not by executing below statement.
Update d1-products set genericdescription =potato chip where
genericdescription =potato chips
Select * from s-nq-ept.
Hence trigger is working.
*_Configuring EPT table:_*
In physical layer right click on supplier2 -->connection pool -->import
metadata -->import s-nq-ept table -->finish.
Tools menu -->utilities -->select oracle BI event tables -->execute

-->select s-nq-ept -->provide pooling frequency as 2 mins -->ok -->check

in changes -->ok.
*_Testing:_*
Develop a report with specific description & make sure cache is created.
Update some data in D1-products, then after 2 mins(pooling frequencies)
-->cache will be cleaned as well s-nq-ept table will be truncated.
*_Odbc functions:_*
We have four types of ODBC functions, those are useful to purge cache
programmatically & those functions are
1.

SA purge all cache.

2.

SA purge cache by db.

3.

SA purge cache by table.

4.

SA purge cache by query.

It is a accurate method to purge the cache. Normally these functions

will be executed by ET-team using their post load option.
*_Process for understanding:_*
Develop a report -->make sure cache is created -->administration
-->under maintenance & trouble shooting -->issue sql -->type call SA
purge all cache -->issue sql -->go & see in cache folder. -->cache is
removed.
*_Seeding:_*
Inserting cache into cache folder is called as seeding.
Seedings are two types.
1.

Manual seeding.

2.

By using schedule.

*_1. Manual seeding: _*

Navigate to the report in the catalog -->click on that report -->then
automatically cache will be created.
*_2. By using schedule:_*
Log in to analytics -->develop a report with vs dollars -->save -->name:
seeding report -->new -->agent -->schedule -->frequency : once -->data &
type 2 min. forward to current time. Click on delay content -->select
content as analysis -->browse -->select seeding report -->click on
destinations -->oracle BI server cache -->save -->name: seed agent
-->after 2 mins go to cache folder & notice that a cache file is available.

OBIEE 11G
<http://mkashu.blogspot.in/search/label/OBIEE%2011G>
*
*
*
*
1
<#>
*Kashif*
Kashif: _Cache Management in OBIEE 11g_
Review : Kashif | < http://www.mkashu.blogspot.com >
Update: 13:22 | Rating: 4.5
<https://www.blogger.com/post-edit.g?blogID=6531182046821816297&postID=378967613
6731161005&from=pencil>
Newer Post
<http://mkashu.blogspot.in/2014/05/top-130-sql-interview-questions-and.html>
Older Post
<http://mkashu.blogspot.in/2014/05/multi-user-development-environment-mude.html>

2 comments:
1.
Rakesh Patil
<https://www.blogger.com/profile/06011767166141014690>18 September
2014 at 08:09
<http://mkashu.blogspot.com/2014/05/cache-management-in-obiee-11g.html?showC
omment=1411052951140#c2876019926871732815>
Awesome Bro..Finally i cleared my all doubts..
Reply <javascript:;>Delete
<https://www.blogger.com/delete-comment.g?blogID=6531182046821816297&postID=
2876019926871732815>
2.
ramyaa krishn
<https://www.blogger.com/profile/09871033349988469833>20 October
2014 at 04:54
<http://mkashu.blogspot.com/2014/05/cache-management-in-obiee-11g.html?showC
omment=1413806089924#c3630967043136672399>
Hi,
I have made small changes in moth prompt in analytics page and ran
the report. I got the physical query from cache. Without using
SAPurgeAllCache() how/From where to get the physical query for the
modified one. Can u please help with a solution
Reply <javascript:;>Delete
<https://www.blogger.com/delete-comment.g?blogID=6531182046821816297&postID=
3630967043136672399>
Add comment
<javascript:;>

Load more...
<javascript:;>
<https://www.blogger.com/comment-iframe.g?blogID=6531182046821816297&postID=3789
676136731161005&blogspotRpcToken=3017361>

Links to this post

Create a Link <https://www.blogger.com/blog-this.g>
Blog Archive
* <javascript:void(0)> 2015
<http://mkashu.blogspot.in/search?updated-min=2015-01-01T00:00:00-08:00&upda
ted-max=2016-01-01T00:00:00-08:00&max-results=19>
(19)
o <javascript:void(0)> July
<http://mkashu.blogspot.in/2015_07_01_archive.html> (6)
o <javascript:void(0)> June
<http://mkashu.blogspot.in/2015_06_01_archive.html> (1)
o <javascript:void(0)> May
<http://mkashu.blogspot.in/2015_05_01_archive.html> (6)
o <javascript:void(0)> April
<http://mkashu.blogspot.in/2015_04_01_archive.html> (3)
o <javascript:void(0)> March
<http://mkashu.blogspot.in/2015_03_01_archive.html> (3)
* <javascript:void(0)> 2014
<http://mkashu.blogspot.in/search?updated-min=2014-01-01T00:00:00-08:00&upda
ted-max=2015-01-01T00:00:00-08:00&max-results=50>
(188)
o <javascript:void(0)> November
<http://mkashu.blogspot.in/2014_11_01_archive.html> (42)
o <javascript:void(0)> August
<http://mkashu.blogspot.in/2014_08_01_archive.html> (13)
o <javascript:void(0)> June
<http://mkashu.blogspot.in/2014_06_01_archive.html> (41)
o <javascript:void(0)> May
<http://mkashu.blogspot.in/2014_05_01_archive.html> (17)
+ OBIEE 11g Interview Questions from Virtusa
<http://mkashu.blogspot.in/2014/05/obiee-11g-interview-questions-fro
m.html>
+ To create a database in SQL Server 2008
<http://mkashu.blogspot.in/2014/05/to-create-database-in-sql-server2008.html>
+ Create a database user using SQL Server Management...
<http://mkashu.blogspot.in/2014/05/create-database-user-using-sql-se
rver.html>
+ MS SQL Server 2008 Installation Step by Step
<http://mkashu.blogspot.in/2014/05/ms-sql-server-2008-installation-s
tep-by.html>
+ Scorecard in obiee 11g
<http://mkashu.blogspot.in/2014/05/scorecard-in-obiee-11g.html>
+ KPI in OBIEE 11g
<http://mkashu.blogspot.in/2014/05/kpi-in-obiee-11g.html>
+ Top 130 SQL Interview Questions And Answers

<http://mkashu.blogspot.in/2014/05/top-130-sql-interview-questions-a
nd.html>
+ Cache Management in OBIEE 11g
<http://mkashu.blogspot.in/2014/05/cache-management-in-obiee-11g.htm
l>
+ Multi user development environment (MUDE) in OBIEE...
<http://mkashu.blogspot.in/2014/05/multi-user-development-environmen
t-mude.html>
+ Catalog manager in OBIEE 11g
<http://mkashu.blogspot.in/2014/05/catalog-manager-in-obiee-11g.html
>
+ KPI - (key performance indicator) in OBIEE 11g Ste...
<http://mkashu.blogspot.in/2014/05/kpi-key-performance-of-indicatorin.html>
+ KPI watch list in OBIEE 11g Steps
<http://mkashu.blogspot.in/2014/05/kpi-watch-list-in-obiee-11g-steps
.html>
+ KPI Watch list OBIEE 11g
<http://mkashu.blogspot.in/2014/05/kpi-watch-list-obiee-11g.html>
+ Map viewer in OBIEE 11g - Part -2
<http://mkashu.blogspot.in/2014/05/map-viewer-in-obiee-11g-part-2.ht
ml>
+ Map viewer in OBIEE 11g - Part 1
<http://mkashu.blogspot.in/2014/05/map-viewer-in-obiee-11g-part-1.ht
ml>
+ pdf export not working in obiee 11G
<http://mkashu.blogspot.in/2014/05/pdf-export-not-working-in-obiee-1
1g.html>
+ Top 88 ODI Interview Questions
<http://mkashu.blogspot.in/2014/05/odi-interview-questions.html>
o <javascript:void(0)> March
<http://mkashu.blogspot.in/2014_03_01_archive.html> (1)
o <javascript:void(0)> February
<http://mkashu.blogspot.in/2014_02_01_archive.html> (55)
o <javascript:void(0)> January
<http://mkashu.blogspot.in/2014_01_01_archive.html> (19)
* <javascript:void(0)> 2013
<http://mkashu.blogspot.in/search?updated-min=2013-01-01T00:00:00-08:00&upda
ted-max=2014-01-01T00:00:00-08:00&max-results=50>
(247)
o <javascript:void(0)> December
<http://mkashu.blogspot.in/2013_12_01_archive.html> (3)
o <javascript:void(0)> November
<http://mkashu.blogspot.in/2013_11_01_archive.html> (22)
o <javascript:void(0)> October
<http://mkashu.blogspot.in/2013_10_01_archive.html> (21)
o <javascript:void(0)> September
<http://mkashu.blogspot.in/2013_09_01_archive.html> (92)
o <javascript:void(0)> August
<http://mkashu.blogspot.in/2013_08_01_archive.html> (43)
o <javascript:void(0)> July
<http://mkashu.blogspot.in/2013_07_01_archive.html> (66)
* <javascript:void(0)> 2012
<http://mkashu.blogspot.in/search?updated-min=2012-01-01T00:00:00-08:00&upda
ted-max=2013-01-01T00:00:00-08:00&max-results=1>
(1)
o <javascript:void(0)> August
<http://mkashu.blogspot.in/2012_08_01_archive.html> (1)

<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=BlogArchive&w
idgetId=BlogArchive1&action=editWidget&sectionId=main>

Labels
1z0-482 Dumps
<http://mkashu.blogspot.in/search/label/1z0-482%20Dumps> (2)
1Z0-525 Dumps
<http://mkashu.blogspot.in/search/label/1Z0-525%20Dumps> (1)
BI Publisher Interview Questions
<http://mkashu.blogspot.in/search/label/BI%20Publisher%20Interview%20Questions>
(1)
DATA WAREHOUSE ADMINISTRATOR CONSOLE
<http://mkashu.blogspot.in/search/label/DATA%20WAREHOUSE%20ADMINISTRATOR%20CONSO
LE>
(18)
Data Warehousing
<http://mkashu.blogspot.in/search/label/Data%20Warehousing> (31)
E-BIZ R12
<http://mkashu.blogspot.in/search/label/E-BIZ%20R12> (1)
E-BIZ R12 INSTALLATION
<http://mkashu.blogspot.in/search/label/E-BIZ%20R12%20INSTALLATION> (1)
Essbase
<http://mkashu.blogspot.in/search/label/Essbase> (1)
hmailserver
<http://mkashu.blogspot.in/search/label/hmailserver> (1)
Hyperion
<http://mkashu.blogspot.in/search/label/Hyperion> (1)
Hyperion Essbase
<http://mkashu.blogspot.in/search/label/Hyperion%20Essbase> (2)
Hyperion Essbase Interview Questions
<http://mkashu.blogspot.in/search/label/Hyperion%20Essbase%20Interview%20Questio
ns>
(1)
Hyperion financial management
<http://mkashu.blogspot.in/search/label/Hyperion%20financial%20management>
(1)
Informatica
<http://mkashu.blogspot.in/search/label/Informatica> (141)
Informatica Interview Question
<http://mkashu.blogspot.in/search/label/Informatica%20Interview%20Question>
(36)

Informatica Online Training

<http://mkashu.blogspot.in/search/label/Informatica%20Online%20Training>
(1)
Informatica Training
<http://mkashu.blogspot.in/search/label/Informatica%20Training> (1)
Informatica Training Chennai
<http://mkashu.blogspot.in/search/label/Informatica%20Training%20Chennai> (1)
JAVA
<http://mkashu.blogspot.in/search/label/JAVA> (1)
linux
<http://mkashu.blogspot.in/search/label/linux> (1)
Normalization in Oracle
<http://mkashu.blogspot.in/search/label/Normalization%20in%20Oracle> (1)
OBIA 11.1.1.7.1
<http://mkashu.blogspot.in/search/label/OBIA%2011.1.1.7.1> (1)
OBIA 7.9.6.3
<http://mkashu.blogspot.in/search/label/OBIA%207.9.6.3> (3)
OBIA Installation
<http://mkashu.blogspot.in/search/label/OBIA%20Installation> (33)
OBIEE 10G
<http://mkashu.blogspot.in/search/label/OBIEE%2010G> (8)
OBIEE 11G
<http://mkashu.blogspot.in/search/label/OBIEE%2011G> (128)
OBIEE 11g dumps
<http://mkashu.blogspot.in/search/label/OBIEE%2011g%20dumps> (2)
OBIEE 11g Interview Questions
<http://mkashu.blogspot.in/search/label/OBIEE%2011g%20Interview%20Questions>
(1)
OBIEE certification
<http://mkashu.blogspot.in/search/label/OBIEE%20certification> (2)
OBIEE Interview Question
<http://mkashu.blogspot.in/search/label/OBIEE%20Interview%20Question> (1)
OBIEE Publisher Interview Questions
<http://mkashu.blogspot.in/search/label/OBIEE%20Publisher%20Interview%20Question
s>
(1)
OBIEE TRAINING CHENNAI
<http://mkashu.blogspot.in/search/label/OBIEE%20TRAINING%20CHENNAI> (1)
OBIEE TRAINING ONLINE
<http://mkashu.blogspot.in/search/label/OBIEE%20TRAINING%20ONLINE> (1)
ODI (Oracle data integrator)

<http://mkashu.blogspot.in/search/label/ODI%20%28Oracle%20data%20integrator%29>
(2)
odi 11g certification
<http://mkashu.blogspot.in/search/label/odi%2011g%20certification> (1)
ODI dumps
<http://mkashu.blogspot.in/search/label/ODI%20dumps> (2)
Oracle Administrator
<http://mkashu.blogspot.in/search/label/Oracle%20Administrator> (19)
Oracle Business Intelligence Application
<http://mkashu.blogspot.in/search/label/Oracle%20Business%20Intelligence%20Appli
cation>
(3)
Oracle Data Integrator
<http://mkashu.blogspot.in/search/label/Oracle%20Data%20Integrator> (2)
Oracle Data Integrator Interview questions for experience
<http://mkashu.blogspot.in/search/label/Oracle%20Data%20Integrator%20Interview%2
0questions%20for%20experience>
(1)
Oracle Database 12c Installation steps
<http://mkashu.blogspot.in/search/label/Oracle%20Database%2012c%20Installation%2
0steps>
(1)
Oracle Database Installation in Linux 6
<http://mkashu.blogspot.in/search/label/Oracle%20Database%20Installation%20in%20
Linux%206>
(2)
Oracle E-Business R 12.3
<http://mkashu.blogspot.in/search/label/Oracle%20E-Business%20R%2012.3> (1)
Oracle Hyperion Planning and Budgeting Questionnaire
<http://mkashu.blogspot.in/search/label/Oracle%20Hyperion%20Planning%20and%20Bud
geting%20Questionnaire>
(2)
oracle Joins
<http://mkashu.blogspot.in/search/label/oracle%20Joins> (1)
scorecard in obiee 11g
<http://mkashu.blogspot.in/search/label/scorecard%20in%20obiee%2011g> (1)
SQL Interview Questions
<http://mkashu.blogspot.in/search/label/SQL%20Interview%20Questions> (1)
sql server 2008
<http://mkashu.blogspot.in/search/label/sql%20server%202008> (2)
Sql server installation
<http://mkashu.blogspot.in/search/label/Sql%20server%20installation> (1)
WinSCP

<http://mkashu.blogspot.in/search/label/WinSCP> (1)
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=Label&widgetI
d=Label1&action=editWidget&sectionId=main>

Informatica Transformation
* Union Transformation
<http://mkashu.blogspot.in/2013/09/union-transformation-in-informatica.html>
* Stored Procedure Transformations
<http://mkashu.blogspot.in/2013/09/Stored-Procedure-Transformations-In-Infor
matica.html>
* Source Qualifier Transformation
<http://mkashu.blogspot.in/2013/09/source-qualifier-in-informatica.html>
* Sorter Transformation
<http://mkashu.blogspot.in/2013/09/sorter-transformation-in-informatica.html
>
* Sequence Generator Transformation
<http://mkashu.blogspot.in/2013/09/sequence-generator-in-informatica_5903.ht
ml>
* Router Transformation
<http://mkashu.blogspot.in/2013/09/router-transformation-in-informatica.html
>
* Normalizer Transformation
<http://mkashu.blogspot.in/2013/09/normalizer-transformation-in-informatica.
html>
* Rank Transformation
<http://mkashu.blogspot.in/2013/09/rank-transformation-in-informatica.html>
* Look-up (Un-connected) Transformation
<http://mkashu.blogspot.in/2013/09/Unconnected-Lookup-Transformation-in-Info
rmatica.html>
* Look-up (connected) Transformation
<http://mkashu.blogspot.in/2013/09/Connected-Lookup-Transformation-in-Inform
atica.html>
* Filter Transformation
<http://mkashu.blogspot.in/2013/09/filter-in-informatica.html>
* Expression Transformation
<http://mkashu.blogspot.in/2013/09/expression-transformation-in-informatica.
html>
* <http://mkashu.blogspot.in/2013/09/aggregator-transformation-in-informatica_
1032.html>Aggregator
Transformation
<http://mkashu.blogspot.in/2013/09/aggregator-transformation-in-informatica_
1032.html>
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=TextList&widg
etId=TextList1&action=editWidget&sectionId=sidebarright>
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=HTML&widgetId
=HTML4&action=editWidget&sectionId=sidebarright>

Contact Form
Name

Email *
Message *
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=ContactForm&w
idgetId=ContactForm1&action=editWidget&sectionId=sidebarright>

Popular Posts
*
Top 100 Informatica Interview Questions
<http://mkashu.blogspot.in/2013/09/top-100-informatica-interview-questions.h
tml>
I have attended Informatica interview last week in wipro and couple
of other companies, Question below I faced in those companies. 1...
*
Top 130 SQL Interview Questions And Answers
<http://mkashu.blogspot.in/2014/05/top-130-sql-interview-questions-and.html>
1. Display the dept information from department table. Select *
from dept; 2. Display the details of all employees ...
*
<http://mkashu.blogspot.in/2013/07/obiee-11g-architecture-with-explanation.h
tml>
OBIEE 11G ARCHITECTURE WITH EXPLANATION
<http://mkashu.blogspot.in/2013/07/obiee-11g-architecture-with-explanation.h
tml>
Below diagram describes the standard logical architecture of Oracle
business intelligence 11g system The entire system architecture is c...
*
<http://mkashu.blogspot.in/2014/08/normalization-in-sql-1nf-2nf-3nf-bcnf.htm
l>
Normalization in SQL ((1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
<http://mkashu.blogspot.in/2014/08/normalization-in-sql-1nf-2nf-3nf-bcnf.htm
l>
Normalization: Normalization is step-by-step process of reducing
complexity of an entity by distributing the attributes to differen...
*
<http://mkashu.blogspot.in/2013/09/Unconnected-Lookup-Transformation-in-Info
rmatica.html>
Unconnected Lookup Transformation in Informatica
<http://mkashu.blogspot.in/2013/09/Unconnected-Lookup-Transformation-in-Info
rmatica.html>
Passive Transformation Unlike Connected Transformation that receives
input directly from the mapping pipeline, it receives input fr...
*
<http://mkashu.blogspot.in/2013/09/Connected-Lookup-Transformation-in-Inform
atica.html>
Connected Lookup Transformation in Informatica
<http://mkashu.blogspot.in/2013/09/Connected-Lookup-Transformation-in-Inform
atica.html>
Passive Transformation Used to search To get the related values To
compare the values Used in slowly changing dim...
*
<http://mkashu.blogspot.in/2013/09/sorter-transformation-in-informatica.html

>
sorter transformation in informatica
<http://mkashu.blogspot.in/2013/09/sorter-transformation-in-informatica.html
>
It is an active transformation to sort the data in ascending or
descending order. It has to be used before Active Transformati...
*
Download Informatica 9.5 software
<http://mkashu.blogspot.in/2013/12/download-informatica-95-software.html>
I seen many peoples searching to download informatica software. Just
go to https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru...
*
<http://mkashu.blogspot.in/2013/08/obiee-model-time-series-in-obiee.html>
OBIEE -Time Series in OBIEE
<http://mkashu.blogspot.in/2013/08/obiee-model-time-series-in-obiee.html>
Time Series in obiee Time series functions present the capability to
evaluate and comparing business performance by curre...
*
<http://mkashu.blogspot.in/2013/09/union-transformation-in-informatica.html>
Union Transformation in Informatica
<http://mkashu.blogspot.in/2013/09/union-transformation-in-informatica.html>
Active Transformation Merges similar data coming from
heterogeneous (Oracle,SQl Server) or homogenous sources...
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=PopularPosts&
widgetId=PopularPosts1&action=editWidget&sectionId=sidebarright>
Powered by Blogger <https://www.blogger.com>.
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=Attribution&w
idgetId=Attribution1&action=editWidget&sectionId=sidebarright>
<http://mkashu.blogspot.com/2013/07/methods-of-datawarehouse.html>
Methods of DataWarehouse
<http://mkashu.blogspot.com/2013/07/methods-of-datawarehouse.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/requirements-for-data-warehouses.html>
Requirements For Data Warehouses
<http://mkashu.blogspot.com/2013/07/requirements-for-data-warehouses.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/issues-in-data-warehousing.html>
Issues in Data warehousing
<http://mkashu.blogspot.com/2013/07/issues-in-data-warehousing.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/rules-of-datawarehouse.html>
Rules of Datawarehouse
<http://mkashu.blogspot.com/2013/07/rules-of-datawarehouse.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/data-warehouse-tools.html>
Data warehouse tools
<http://mkashu.blogspot.com/2013/07/data-warehouse-tools.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/datawarehouse-disadvantages.html>

Datawarehouse Disadvantages
<http://mkashu.blogspot.com/2013/07/datawarehouse-disadvantages.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/datawarehouse-benfits.html>
Datawarehouse Benfits
<http://mkashu.blogspot.com/2013/07/datawarehouse-benfits.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/difference-between-datawarehouse-and.html>
Difference Between Datawarehouse and Database
<http://mkashu.blogspot.com/2013/07/difference-between-datawarehouse-and.html>
By Kashif M - 0 comment
Get this widget
<www.newbloggertips.com/2013/02/add-awesome-random-post-widget-to.html>
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=HTML&widgetId
=HTML1&action=editWidget&sectionId=sidebarright>
<http://mkashu.blogspot.com/2013/07/correct-rejected-files-in-informatica.html>
correct the rejected files in Informatica
<http://mkashu.blogspot.com/2013/07/correct-rejected-files-in-informatica.html>
By Kashif M - 1 comment
<http://mkashu.blogspot.com/2013/07/session-level-performance-in-informatica.htm
l>
Informatica - Session optimizing
<http://mkashu.blogspot.com/2013/07/session-level-performance-in-informatica.htm
l>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/repository-level-performance-in.html>
Repository level Performance in Informatica
<http://mkashu.blogspot.com/2013/07/repository-level-performance-in.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/mapping-level-performance-in-informatica.htm
l>
Informatica - Mapping Level Performance
<http://mkashu.blogspot.com/2013/07/mapping-level-performance-in-informatica.htm
l>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/improve-performance-in-informatica.html>
Improve Performance In Informatica
<http://mkashu.blogspot.com/2013/07/improve-performance-in-informatica.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/index-in-informatica.html>
INDEX IN INFORMATICA
<http://mkashu.blogspot.com/2013/07/index-in-informatica.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/performance-tips-in-informatica.html>
PERFORMANCE TIPS IN INFORMATICA

<http://mkashu.blogspot.com/2013/07/performance-tips-in-informatica.html>
By Kashif M - 0 comment
<http://mkashu.blogspot.com/2013/07/filter-condition-in-informatica.html>
FILTER CONDITION IN INFORMATICA
<http://mkashu.blogspot.com/2013/07/filter-condition-in-informatica.html>
By Kashif M - 0 comment
Get this widget
<www.newbloggertips.com/2013/02/add-awesome-random-post-widget-to.html>
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=HTML&widgetId
=HTML5&action=editWidget&sectionId=sidebarright>

*
About Me
My Photo <https://plus.google.com/100593951254781598380>
Kashif M <https://plus.google.com/100593951254781598380>
I m Kashif, Certified OBIEE Consultant working with 7stl in
Chennai. I am here to share my experience, ideas, thoughts and
issues while working with Oracle and in Data warehousing products.
View my complete profile
<https://plus.google.com/100593951254781598380>
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=Profile&w
idgetId=Profile1&action=editWidget&sectionId=footersec1>
*
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=HTML&widg
etId=HTML6&action=editWidget&sectionId=footersec2>
*
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=HTML&widg
etId=HTML3&action=editWidget&sectionId=footersec3>

Followers
<//www.blogger.com/rearrange?blogID=6531182046821816297&widgetType=Followers
&widgetId=Followers1&action=editWidget&sectionId=footersec3>
* Home <#>
* About <http://mkashu.blogspot.com>
* Support Center <http://mkashu.blogspot.in/2013/08/contact-me.html>
Copyright 2014 Mkashu. Designed by Templateism
<http://www.templateism.com>