Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Monday, 9 September 2013

Type of Cache in Informatica


By on 01:47:00



1. Data Cache

2. Index Cache

3. Static cache

4. Dynamic cache

5. Persistent Cache

6. Re cache (Refill Cache)

7. Shared Cache

Data Cache contains condition-satisfied data. Carries output of relationship.

Index Cache contains conditioned columns. Indexed columns are the columns on whose basis we relate the data.

Persistent Cache – To reuse the lookup table data for the next runs, it is saved in the Persistent Cache.

Suppose data is same for 2-3 runs, it is fetched from the P.Cache, instead of looking up in the Lookup DB.

Recache – To remove the existing data from the P.Cache and looks into LupDB again.

Shared Cache -

1 comments:

  1. ID STRT TIME END TIME CAL COMMENETS/explaintaion
    INC2 2/5/2014 12:00 2/5/2014 13:00 1 start time - end time =1 hour
    INC3 2/5/2014 12:30 2/5/2014 13:30 30 12.30 falls in above time so till one its occupied so extra time is above 1 i.e 30 mins
    INC4 2/5/2014 12:45 2/5/2014 13:00 0 start time is 12.45 it falls in window of above i.e 12.00 and end time is 1 it also falls in above end time i.e 1.30 so calculation is 0
    INC1 2/5/2014 11:00 2/5/2014 12:30 1 11 is prior to 12 so 11 am to 12 pm its 1 hour ..end time is 12.30 it falls in window of 1.30



    Assume that we start from 1st record we store the start time and end time as some variable now calculation is nothing but start time - end time .for 1st record the differnce between start time and end time is 1 hour .for second row start time is 12.30 so it falls in window of 12.00 pm ( the start variable value) and end time is 1.30 and it goes beyond 1 of previous one so we set the new end time variable as 1.30 and the difference is 30 min since the earlier case was between 12 pm to 1 pm and second case is raised at 12.30 pm and end time is 1.30 so extra time is 30 mins .same calculation goes on for rest 2 rows.


    we have id , start time and end time we have to calculate the cal column data and it should be done through sql or informatica.

    ReplyDelete

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)