New York Oracle Users Group (NYOUG) Long Island SIG
New York Oracle Users Group (NYOUG)Long Island SIGOracle Data Integrator (ODI) Best Practices Do You Know How Flexible ODI Is?Gürcan OrhanSoftware Architect & Expert ress.comhttp://www.twitter.com/gurcan 012 Gürcan Orhan – NYOUG LI SIG Webinar
WHO AM I ? 16 years of IT experience. 9 years of DWH experience. 5 years of Oracle Data Integrator experience, 4 years of Oracle Warehouse Builder experience.Cognos, Microstrategy, Business Objects, OBIEESybase Power Designer, CA ERwin Data ModelerJoined Turkcell October 2008, Turkcell Technology March 2010.Oracle Excellence Awards - Technologist of the Year 2011 :Enterprise Architect(Oracle Magazine Editors’ Choice of Awards, Enterprise Architect)DWH & BI Chair : TROUG (Turkish Oracle User Group)Published Customer Snapshot for NODI @Oracle.comPublished video about ODI @Oracle.com (Oracle Media Network)Presenter in Oracle Open World since 2010 (hat-trick)07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar
My definition of ODIODI (Oracle Data Integrator) is a tool,that can talk,or learn how to talk,with any database system,or any operating system,in its own language.This is the power of ODI.07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar
ATTENTION !!!Make sure you have; Backup your repository Backup your Knowledge Modules(export, duplicate) Backup your necessary ODI developmentBefore trying something in your environmentRemember to create a zzz Test folder and test before apply07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar4
Variables Use a variable within a variableselect count(1) from msdb.dbo.sysjobhistorywhere step id 0and run status 1and job id (select job id from msdb.dbo.sysjobswhere name 'My BI Job')and run date CAST(SUBSTRING('#V SYSDATE',1,8) as 4/odi-variables/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar5
Variables Use a odiRef function within a variableSELECT *FROM odiwd.snp session sess,odiwd.snp step log step,odiwd.snp sess task sess task,odiwd.snp exp txt exp txtWHERE sess.sess no step.sess noAND sess.sess no sess task.sess noAND step.nno sess task.nnoAND step.i txt step mess exp txt.i txtAND step.step status 'E'AND exp txt.txt ord 0AND sess.sess no % odiRef.getSession("SESS NO")% SELECT NVL(MAX(ALARM ID), 0) FROM % odiRef.getSchemaName("MYDB.DWH", "D")% .TABLE NAMESELECT NVL(MAX(ALARM ID), 0) FROM DWH.TABLE i-variables/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar6
HINTS in OracleOracle’s most powerful querying attribute when in right hands.An Oracle hint is an optimizer directive that is embedded intoan SQL statement to suggest to Oracle how the statementshould be executed.Most common hints in DWH system; APPEND PARALLEL USE HASH USE MERGE FULL INDEX ORDERED MERGEhttp://psoug.org/reference/hints.html or just google «Oracle hints»07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar7
KM’s How to apply static HINTS.HINTS.07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar8
KM’s How to apply dynamic HINTS.Step 1 : Create OPTIONS for KM’s07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar9
KM’s How to apply dynamic HINTS.Step 2 : Insert this OPTIONS into KM’sinsert % odiRef.getOption("INSERT HINT")% into % snpRef.getTable("L","TARG NAME","A")% select % odiRef.getOption("SELECT HINT")% % snpRef.getPop("DISTINCT ROWS")% % snpRef.getColList("", "[EXPRESSION]\t[ALIAS SEP][CX COL NAME]", ",\n\t", "", "")% from % snpRef.getFrom()% INSERT /* APPEND PARALLEL(t3, 8) */INTO t3SELECT /* parallel(t1) parallel(t2)ordered use hash(t2) index(t1 t1 abc)index(t2 t2 abc) */ COUNT(*)FROM t1, t2WHERE t1.col1 t2.col1;07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar10
Adding DatatypesRight Click Insert 8/adding-datatypes-to-odi/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar11
Adding FunctionsTopology Manager Languages SQL Aggregate (or adding-functions-to-odi/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar12
Archiving ODI Logs Required tables.Repository table list for logging of ODI stored in workrepository schemaSNP EXP TXTARC SNP EXP TXTSNP SCEN REPORTARC SNP SCEN REPORTSNP SESS STEPARC SNP SESS STEPSNP SESS TASKARC SNP SESS TASKSNP SESS TASK LOGSNP SESS TXT LOGSNP SESSIONSNP STEP LOGCreate these tables (withoutreferential integrity,constraints, indexes, etc.)with a suffix or prefix in adifferent schema.ARC SNP SESS TASK LOGARC SNP SESS TXT LOGARC SNP SESSIONARC SNP STEP LOGSNP STEP REPORTARC SNP STEP REPORTSNP TASK TXTARC SNP TASK TXTSNP VAR DATAARC SNP VAR DATASNP VAR SESSARC SNP VAR chiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar13
Archiving ODI Logs Logs Reverse.Reverse all required tables in hiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar14
Archiving ODI Logs Create interfaces.I SNP EXP TXTSNP EXP TXTARC SNP EXP TXTTRUNC(SNP EXP TXT.FIRST DATE) TRUNC(SYSDATE) #V Purge Log 12/12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar15
Archiving ODI Logs Create interfaces.I SNP SCEN REPORTSNP SCEN REPORTARC SNP SCEN REPORTSNP SCEN REPORT.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SCEN REPORT.SESS BEG) TRUNC(SYSDATE)- #V Purge Log 12/12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar16
Archiving ODI Logs Create interfaces.I SNP SESS STEPSNP SESS STEPSNP SESSIONARC SNP SESS STEPSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP SESS STEP.SESS NO SNP SESSION.SESS iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar17
Archiving ODI Logs Create interfaces.I SNP SESS TASKSNP SESS TASKSNP SESS STEPSNP SESSIONARC SNP SESS TASKSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP SESS TASK.SESS NO SNP SESS STEP.SESS NO ANDSNP SESS TASK.NNO SNP SESS STEP.NNOSNP SESS STEP.SESS NO SNP SESSION.SESS iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar18
Archiving ODI Logs Create interfaces.I SNP SESS TASK LOGSNP SESS TASK LOGSNP STEP LOGSNP SESS STEPSNP SESSIONARC SNP SESS TASK LOGSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP SESS TASK LOG.NNO SNP STEP LOG.NNO ANDSNP SESS TASK LOG.SESS NO SNP STEP LOG.SESS NO ANDSNP SESS TASK LOG.NB RUN SNP STEP LOG.NB RUNSNP STEP LOG.SESS NO SNP SESS STEP.SESS NO ANDSNP STEP LOG.NNO SNP SESS STEP.NNOSNP SESS STEP.SESS NO SNP SESSION.SESS iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar19
Archiving ODI Logs Create interfaces.I SNP SESS TXT LOGSNP SESS TXT LOGSNP SESS TASK LOGSNP STEP LOGSNP SESS STEPSNP SESSIONARC SNP SESS TXT LOGSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP SESS TXT LOG.SESS NO SNP SESS TASK LOG.SESS NO ANDSNP SESS TXT LOG.NNO SNP SESS TASK LOG.NNO ANDSNP SESS TXT LOG.NB RUN SNP SESS TASK LOG.NB RUN ANDSNP SESS TXT LOG.SCEN TASK NO SNP SESS TASK LOG.SCEN TASK NOSNP SESS TASK LOG.NNO SNP STEP LOG.NNO ANDSNP SESS TASK LOG.SESS NO SNP STEP LOG.SESS NO ANDSNP SESS TASK LOG.NB RUN SNP STEP LOG.NB RUNSNP STEP LOG.SESS NO SNP SESS STEP.SESS NO ANDSNP STEP LOG.NNO SNP SESS 5/archiving-odi-logs/07.Dec.2012SNP SESS STEP.SESS NO SNP SESSION.SESS NO Gürcan Orhan – NYOUG LI SIG Webinar20
Archiving ODI Logs Create interfaces.I SNP SESSIONSNP SESSIONARC SNP SESSIONSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log 12/12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar21
Archiving ODI Logs Create interfaces.I SNP STEP LOGSNP STEP LOGSNP SESS STEPSNP SESSIONARC SNP STEP LOGSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP STEP LOG.SESS NO SNP SESS STEP.SESS NO ANDSNP STEP LOG.NNO SNP SESS STEP.NNOSNP SESS STEP.SESS NO SNP SESSION.SESS iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar22
Archiving ODI Logs Create interfaces.I SNP STEP REPORTSNP STEP REPORTSNP SCEN REPORTARC SNP STEP REPORTSNP SCEN REPORT.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SCEN REPORT.SESS BEG) TRUNC(SYSDATE)- #V Purge Log RetentionSNP STEP REPORT.SCEN NO SNP SCEN REPORT.SCEN NO ANDSNP STEP REPORT.SCEN RUN NO SNP SCEN REPORT.SCEN RUN iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar23
Archiving ODI Logs Create interfaces.I SNP TASK TXTSNP TASK TXTSNP SESS TASKSNP SESS STEPSNP SESSIONARC SNP TASK TXTSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log RetentionSNP TASK TXT.SESS NO SNP SESS TASK.SESS NO ANDSNP TASK TXT.NNO SNP SESS TASK.NNO ANDSNP TASK TXT.SCEN TASK NO SNP SESS TASK.SCEN TASK NOSNP SESS TASK.SESS NO SNP SESS STEP.SESS NO ANDSNP SESS TASK.NNO SNP SESS STEP.NNOSNP SESS STEP.SESS NO SNP SESSION.SESS iving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar24
Archiving ODI Logs Create interfaces.I SNP VAR DATASNP VAR DATAARC SNP VAR DATASNP VAR DATA.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP VAR DATA.FIRST DATE) TRUNC(SYSDATE) #V Purge Log 12/12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar25
Archiving ODI Logs Create interfaces.I SNP VAR SESSSNP VAR SESSARC SNP VAR SESSSNP SESSION.CONTEXT CODE 'PRODUCTION' ANDTRUNC(SNP SESSION.SESS BEG) TRUNC(SYSDATE) #V Purge Log 12/12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar26
Archiving ODI Logs Create procedureCreate a delete procedure Delete from parent to childCOMMANDDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SESS TXT LOG ADELETEWHERE SESS NO INODIWD.SNP SESS TXT LOG (SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)DELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SESS TASK LOG ADELETEWHERE SESS NO INODIWD.SNP SESS TASK LOG (SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)DELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP TASK TXT ADELETEWHERE SESS NO INODIWD.SNP TASK TXT(SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)DELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP STEP LOG ADELETEWHERE SESS NO INODIWD.SNP STEP LOG(SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)DELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SESS TASK ADELETEWHERE SESS NO INODIWD.SNP SESS TASK(SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)ORDER STEP /12/05/archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar27
Archiving ODI Logs Create procedureORDER STEP NAMECOMMANDDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SESS STEP AWHERE SESS NO IN(SELECT SESS NO FROM ODIWD.SNP SESSION SESSWHERE TRUNC(SESS.SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention)50DELETEODIWD.SNP SESS STEP60DELETEODIWD.SNP VAR DATADELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP VAR DATA AWHERE TRUNC(A.FIRST DATE) TRUNC(SYSDATE) - #V Purge Log Retention70DELETEODIWD.SNP VAR SESSDELETE FROM ODIWD.SNP VAR SESSWHERE SESS NO IN (SELECT SESS NO FROM ODIWD.SNP SESSION AWHERE TRUNC(SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention80DELETEODIWD.SNP EXP TXTDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP EXP TXT AWHERE TRUNC(A.FIRST DATE) TRUNC(SYSDATE) - #V Purge Log Retention90DELETEODIWD.SNP SESSIONDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SESSION AWHERE TRUNC(SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention100DELETEDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP STEP REPORT AODIWD.SNP STEP REPORT WHERE TRUNC(A.STEP BEG) TRUNC(SYSDATE) - #V Purge Log Retention110DELETEDELETE /* USE HASH(A) PARALLEL(A) */ FROM ODIWD.SNP SCEN REPORT AODIWD.SNP SCEN REPORT WHERE TRUNC(SESS BEG) TRUNC(SYSDATE) - #V Purge Log Retention07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar28
Archiving ODI Logs PackagingRunning in «Asynchronous Mode»Running in «Asynchronous archiving-odi-logs/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar29
Handling AlertsRunning in «Asynchronous Mode»Error HandlerMax. Number of Failed Child Sessions 1Raise Error(error refresh variable)Mail body(refresh variable)Send i-alert-mechanism/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar30
Handling – {in ETL} – Data QualityKnown data quality issues that can be covered in ETLStep 1 : Prepare your data quality scripts.Step 2 : Put those scripts into files.Step 3 : Read contents of those files or create a table forscripts. Execute this script into your database, insert output toan ERROR table.Step 4 : Select count from ERROR table by ERROR CODE andloop it from beginning to end for sysdate.Step 5 : Send e-mail for each script, attach the appropriate fileand show how many rows are generated in this ERROR di-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar31
Handling – {in ETL} – Data QualityStep 1 : Prepare your data quality scripts. If you are generating a hierarchical tree, make sure yourevery node connects to its parent Check duplicates in names, addresss and other importantfields Check primary key behaviour from your /odi-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar32
Handling – {in ETL} – Data QualityStep 2 : Put those scripts into files. Create as many scripts you can. Copy files to operating system, where agent is running.You should have read grant for this /30/odi-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar33
Handling – {in ETL} – Data QualityStep 3 : Create tables for scripts and output.CREATE TABLE MY ERROR TABLE(DATETIME DATE,TRX ID INTEGER,ERROR CODE NUMBER(2),ERROR DESC VARCHAR2(150 BYTE))TABLESPACE MY TBSLOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING;CREATE TABLE MY ERROR SCRIPTS(ERROR CODE NUMBER(2),ERROR DESC VARCHAR2(150 BYTE),ERROR SCRIPT DWH CLOB,ERROR SCRIPT OLTP CLOB)LOB (ERROR SCRIPT DWH) STORE AS (TABLESPACE MY TBSENABLE STORAGE IN ROW CHUNK 32768 RETENTION NOCACHE NOLOGGING STORAGE(INITIAL 160K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0))LOB (ERROR SCRIPT OLTP) STORE AS (TABLESPACE MY TBSENABLE STORAGE IN ROW CHUNK 32768 RETENTION NOCACHE NOLOGGING STORAGE(INITIAL 160K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0))TABLESPACE MY TBSLOGGING NOCOMPRESS NOCACHE NOPARALLEL 1/30/odi-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar34
Handling – {in ETL} – Data QualityStep 3 : Read scripts. Execute this script into your database,insert output to an ERROR table. Delete todays records; Execute all Error Scripts; (since I am changing my own codes,below codes must be rewritten to your environment)DECLARETYPE TransactionRec IS RECORD (transaction id integer);TYPE TransactionSet IS TABLE OF TransactionRec;ContractSet TransactionSet;CURSOR C1 ISselect ERROR CODE, ERROR DESC, ERROR SCRIPT DWH from % odiRef.getSchemaName("DB.MY SCHEMA", "D")% .ERROR SCRIPTS;BEGINFOR C1 REC IN C1 LOOPEXECUTE IMMEDIATE to char(C1 REC.ERROR SCRIPT DWH) BULK COLLECTINTO ContractSet;IF ContractSet.FIRST IS NOT NULL THENFOR i IN ContractSet.FIRST.ContractSet.LASTLOOPINSERT INTO % odiRef.getSchemaName("DB.MY SCHEMA", "D")% .MY ERROR TABLE (DATETIME,TRANSACTION ID, ERROR CODE, ERROR DESC) VALUES(TO DATE('SYSDATE', 'YYYYMMDD'), ContractSet(i). transaction id, C1 REC.ERROR CODE,C1 REC.ERROR DESC);COMMIT;END LOOP;delete from % odiRef.getSchemaName("DB.MY SCHEMA",END IF;"D")% .MY ERROR TABLE where DATETIME TO DATE('SYSDATE', 'YYYYMMDD')END 30/odi-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar35
Handling – {in ETL} – Data QualityStep 4 : Read ERROR table by ERROR CODE and loop it frombeginning to end.RefreshERROR CODE COUNTProcedure to run scripts.Output insert intoMY ERROR TABLE dailyAssign the initial ERROR CODECheck if last ERROR CODEIncrement ERROR CODE ( 1)Check ERROR CODE COUNT 0Refresh mail bodySend i-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar36
Handling – {in ETL} – Data QualityStep 5 : Send e-mail for each script, attach the appropriate fileand show how many rows are generated in this ERROR CODE. Mail Server : #V MAIL SERVER IP From : This is static, user that you are sending mail. TO : #V ERROR MAIL TO (need to be refreshed in the beginning ofyour ETL or current package) CC : #V ERROR MAIL CC (need to be refreshed in the beginning of yourETL or current package) BCC : #V ERROR MAIL BCC (need to be refreshed in the beginning ofyour ETL or current package) Subject : There are #V MY ERROR COUNT errors exist in your system(Error Code #V MY ERROR CODE) Attachment : /data/my errors/MY Error #V MY ERROR CODE.txt (willrepresent as /data/my errors/MY Error 1.txt initially, then will attachregarding file in the loop, every step will attach its own script file) Message Body : #V MY ERROR i-handling-dq/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar37
File2Table SummaryStep 1 : Operating system foldersStep 2 : IKM Knowledge ModuleStep 3 : ETL FILE LOG (database table)Step 4 : ODI Procedure to rename files for external table usageStep 5 : ODI Procedures to finish working with filesStep 6 : ODI Procedure to Get File List of operating systemStep 7 : ODI Interface (loading and transforming)Step 8 : Some ODI VariablesStep 9 : ODI Package for running everything in right oading-multiple-files-with-odi/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar38
File2Table Preparing environment, folders (Step 1)Illustration for files received from «invoice loading-multiple-files-with-odi/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar39
File2Table Preparing environment, IKM (Step 2) Copy current KM : IKM SQL Control Append Rename as : IKM SQL Control Append (Direct Load,HINT) Add Options : «SELECT HINT», «INSERT HINT» Add New Row : «Parallel DML», Transaction 0, No Commitalter session enable parallel dml Modify : «Insert new rows» to Transaction 0, No Commit Add New fixed Row : «Commit transaction» to Transaction 0,Commit/* commit ing-multiple-files-with-odi/07.Dec.2012 Gürcan Orhan – NYOUG LI SIG Webinar40
File2Table Preparing environment, IKM (Step 2)INSERT /* APPEND PARALLEL(4) */INTO ODIDB.MY TARGET TABLE(MY TARGET COLUMN 1,MY TARGET COLUMN
5 years of Oracle Data Integrator experience, 4 years of Oracle Warehouse Builder experience. Cognos, Microstrategy, Business Objects, OBIEE Sybase Power Designer, CA ERwin Data Modeler Joined Turkcell October 2008, Turkcell Technology March 2010. Oracle Excellence Awards - Technologist of the Year 2011 : Enterprise Architect
New York Buffalo 14210 New York Buffalo 14211 New York Buffalo 14212 New York Buffalo 14215 New York Buffalo 14217 New York Buffalo 14218 New York Buffalo 14222 New York Buffalo 14227 New York Burlington Flats 13315 New York Calcium 13616 New York Canajoharie 13317 New York Canaseraga 14822 New York Candor 13743 New York Cape Vincent 13618 New York Carthage 13619 New York Castleton 12033 New .
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M
Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.
Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces
