ODI AGENTS

Oracle Data Integrator 12c - Creating a Standalone Agent

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent/index.html?cid=7949&ssid=111853933022703

Oracle Data Integrator 12c - Creating a Collocated Agent

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent_collocated/index.html

Persistent Cache

1. Open existing Mapping m_connected_lkp_deptname
2. 
3. Double Click on lookup → Go to properties tab → Enable Lookup cache Persistent
4. 
5. Save it → Go to corresponding workflow → right click on session → click on refresh mapping
6. 
7. Save it
8. Notice that in cache default folder is empty
1. Note : the default path is C:\Informatica\9.1.0\server\infa_shared\Cache
9. 
10. Run the workflow
11. Notice that target table loaded with data and also cache created
12. 
13. 
14. To prove from next run onwards it will read from cache → change some source data (in my case i changed dname sales123456 to sales) → commit
15. 
16. enable Truncate target table option
17. Run the workflow → notice that the changed data of source not loaded in to target as it read from cache
18. to read from source by skipping cache  → enable recache from lookup cache
19. 
20. save it → run workflow
21. observe output ,the changed data of source loaded  into target
22. 

Active Lookup

Step1: Create a mapping

1. Use source as dept
2. Create a table as target and import into informatica
1. CREATE TABLE tgt_Active_lookup(
2.    DEPTNO number,
3.    DNAME  varchar2(30),
4.    ENAME  varchar2(30),
5.    SAL    number,
6.    LOC    varchar2(30)
7. )
8. 
3. Import into informatica as target
4. Create a mapping with the name of m_Active_lookup
5. Drag and drop source dept and target tgt_active_lookup
6. click on lookup tranformation and select emp as lookup table and enable Return all values on Multiple match
7. 
8. Click on ok
9. Drag and drop deptno,dname,loc from source qualifier to lookup transformation
10. Double click on Lookup click on condition tab and select condition as shown
11. 
12. Observer policy property
13. 
14. Click on ok
15. connect corresponding columns from lookup to target
16. 
17. save it
18. create workflow and session
19. run it observe run properties
20. 
21. Source input records to lookup are 4 and output records are 21 hence lookup acting as a Active transformation

LOOKUP IN ODI 11G

Step 1: Creating target table

1. open SQL DEVELOPER and execute below script
2. 
3. Reverse Engineer LKP_EMP_DNAME_LOC table into RRITEC_MODEL_TARGET

Step 2: Creating INTERFACE

1. Create a INTERFACE with the name of m_LOOKUP_DNAME_LOC
2. DRAG AND DROP SOURCE emp AND TARGET LKP_EMP_DNAME_LOC
3. Click on the lookup button
4. 
5. select driving and lookup tables
6. 
7. select deptno column → click on join
8. 
9. Click on finish
10. click on flow tab → select target → select flow_control =False
11. save → run → observe output
12. 

Loading Flat File to Table in ODI 11g

Loading Flat File to Table in ODI 11g

Step1: Creating Flat File

1. Navigate to folder C:\OBIEE_HOME\Oracle_ODI1\oracledi\RRITEC
2. Create a text file as shown → name it as emp → save → close
3. 

Step 2: Creating File data server and physical schema

1. Open ODI 11g Studio
2. Go to topology tab
3. Right click on file technology
4. Click on new data server → provide below information
5. 
6. Click on JDBC → provide below information
7. 
8. Click on save
9. Right Click on RRITEC_FLATFILES data server → click on new physical schema → provide as shown
10. 
11. Click on save → click on ok

Step 3: Creating Logical schema and mapping to context

1. Expand logical architecture → right click on file technology → click on new logical schema → give name and map to context  → save
2. 

Step 4: Creating Model

1. Goto designer navigator → under the models section → right click on RRITEC model Folder  → Click on new Model → Provide as shown
2. 
3. save → Close
4. Right clcik on above model → clik on new data store → in definition tab  
5. 
6. Click on files tab
7. 
8. Click on columns tab
9. 
10. save → close

1. Connect to your target schema( ex : B10711GTDBU)
2. Execute below script
3. 
4. Reverse engineer this into target model
5. 

Step 6: Creating interface

1. Expand projects → expand RRITEC folder → Right click on interface → new interface
2. name it as m_flatfile_to_table
3. Click on mapping tab
4. Drag and drop source and target
5. Make sure automatic source to mapping created and select the workspace as staging area
6. 
7. Select flow tab → select source → select LKM as LKM FILE TO SQL
8. 
9. Select target → select IKM as IKM SQL CONTROL APPEND
10. 
11. select the option FLOW_CONTROL = FALSE
12. save → run
13. Observe output
14. 

Step 6: Add filter to above interface

1. Duplicate above interface and rename as m_flatfile_to_table_filter
2. click on mapping tab → from source drag and drop Deptno column in to empty work area
3. select the filter object → provide below condition
4. 
5. Click on flow tab
6. select target → select truncate option as true
7. 
8. save → run → observe output
9. 

Weblogic Server upgrade from 10.3.5 to 10.3.6 error

Fatal error occurred during file installation .the installer will clean up and exit.
beasvc .exe file is busy

End process beasvc.exe from task manager and try to install again

Guidelines to post reviews and likes

1. Like RRITEC face Book Page
• Click on URL https://www.facebook.com/rritec/reviews
• Click on write review  -->  type review and write your comments and give required star rating 

1. 2. Post review in RRITEC Face Book Page

1. Click on URL https://www.facebook.com/rritec/reviews









3. Post review in RRITEC Blog Page (OBIEE/ODI/INFORMATICA..etc) 

• Navigate to required page of blog Page (ex OBIEE ,ODI,..etc)   http://rritec.blogspot.in/p/obiee.html
• scroll to bottom of the page --> type it and publish it 
•  
  

4 . Add to blog to get updates from us

• Go to blog http://rritec.blogspot.in/
• Click on Join this site and follow the wizard
•