TYPES OF LOOKUP CACHE

Informatica Lookups can be cached or un-cached (No cache) and Cached lookup can be either static or dynamic. A static cache is one which does not modify the cache once it is built and it remains same during the session run. On the other hand, A dynamic cache is refreshed during the session run by inserting or updating the records in cache based on the incoming source data. By default, Informatica cache is static cache.

A lookup cache can also be divided as persistent or non-persistent based on whether Informatica retains the cache even after the completion of session run or deletes it

DIFFERENCE BETWEEN ROUTER AND FILTER

Router	Filter
Router transformation divides the incoming records into multiple groups based on some condition. Such groups can be mutually inclusive (Different groups may contain same record)	Filter transformation restricts or blocks the incoming record set based on one given condition.
Router transformation itself does not block any record. If a certain record does not match any of the routing conditions, the record is routed to default group	Filter transformation does not have a default group. If one record does not match filter condition, the record is blocked
Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C)	Filter acts like WHERE condition is SQL.

DIFFERENCES BETWEEN CONNECTED AND UNCONNECTED LOOKUP

The differences are illustrated in the below table

Connected Lookup	Unconnected Lookup
Connected lookup participates in dataflow and receives input directly from the pipeline	Unconnected lookup receives input values from the result of a LKP: expression in another transformation
Connected lookup can use both dynamic and static cache	Unconnected Lookup cache can NOT be dynamic
Connected lookup can return more than one column value ( output port )	Unconnected Lookup can return only one column value i.e. output port
Connected lookup caches all lookup columns	Unconnected lookup caches only the lookup output ports in the lookup conditions and the return port
Supports user-defined default values (i.e. value to return when lookup conditions are not satisfied)	Does not support user defined default values

HOW TO IDENTIFY THE OBIEE REPORTS WHICH ARE NOT USED FROM LONG TIME

How to create catalog report:
1.First open File-> Open Catalog 

2.Then enter the credentials and click on OK and then again OK on the pop up that comes.

 3.Expand Catalog Root and select Shared Folder
 4.Then in the toolbar expand Tools -> Create Report and this appears.

 5.Select ‘Select Type to report on’ as ‘Analysis’ and in the ‘Available Columns’ list select ‘Name’, ‘Path’ and bring them to ‘Columns in the Report’ sectionCheck the Distinct option as well.Then Click Ok.

 6.In the Report Preview add the Path to “Save Report to” to store the Excel and select Excel Format checkbox and then click on OK.

How to create report in Answers for used reports:
 1). Login to production BI .

  2). Click New->Analysis and select Usage Tracking Subject area
  3). In Usage Tracking Subject area, expand Topic folder and select Query Type and Webcat Path columns

  4). Add a valued ‘Report’ to the Query Type column filter and click OK

  5). Add ‘%/users/%’ by selecting Operator as ‘is not LIKE (pattern match)’ for Webcat Path column and click OK

  6). Click on Results Tab

 7). After getting the report click on  icon and select Excel->Excel 2003+ to download the report to excel Below Highlighted Report got executed, as a result it has entry in S_NQ_ACCT table thus showing in the usage tracking report.  There are other reports in the same path but they never got executed.