ODI- NATIVE SEQUENCE Generator | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

ODI- NATIVE SEQUENCE Generator


Hi ,

For using Native Sequence generation in ODI interface, you can follow the below steps.


CREATE TARGET TABLE

CREATE TABLE "TARGET"."SEQUENCE_TRIAL"
   ( "FAMILY_ID" NUMBER,
"EMP_NAME" VARCHAR2(255 CHAR)
   )





CREATE SEQ_FAMILY in the TARGET schema

CREATE SEQUENCE SEQ_FAMILY INCREMENT BY 1 MAXVALUE 99999999999999999 MINVALUE 1 CACHE 20;




Import the table into the target model using the selective reverse engineering.



Once the target table is imported to the model, create the interface and map the EMP_NAME to the NAME column from the source as shown below



Create the Sequence:

From the designer tab , projects, click on sequences and create a new sequence SEQ_FAMILY_ID as shown below

Select Native Sequence and select the TARGET schema and use the search utility as shown below to browse our SEQ_FAMILY that was created in the first step



Open the interface and navigate to the MAPPING tab and use the property selector to select the FAMILY_ID column from the target table as shown below.

User the Expression builder to add the SEQUENCE as shown below, click apply and OK.




Make sure you have specified the KEY as shown below in the new sequence column.



Select the IKM as shown below and enable FLOW CONTROL = TRUE



Verify the target table and execute the interface.



The target table is now populated with the NATIVE SEQUENCE as shown below.



Thanks

Sandeep
SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

0 comments:

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands