How to Avoid UnicodeDecodeError while loading data into DataFrame in python

I am trying load CSV data into DataFrame using python. while doing it, below error is occurred. I have found below command resolve this issue. For the future purpose, I am saving it on the blog. Problem:  The file is converted from Excel to CSV then trying to load into DataFrame. Command: dataset=pd.read_csv(‘Online_Retail.csv’) dataset=pd.read_csv(‘Online_Retail.csv’,encoding=’utf-8′) Traceback… Read More How to Avoid UnicodeDecodeError while loading data into DataFrame in python

Sequences in ODI 12c

Scope: Global Project Types of sequences: Standard Specific Native Syntax:  #<SEQUENCE_NAME>_NEXTVAL :<SEQUENCE_NAME>_NEXTVAL Ex: #DEMO_01.NATIVE_SQ_NEXTVAL #DEMO_01.NATIVE_SQ_CURRVAL A bind variable in SQL statements, using the :<SEQUENCE_NAME>_NEXTVAL Ex: :DEMO_01.NATIVE_SQ_NEXTVAL :DEMO_01.NATIVE_SQ_CURRVAL Sequences are available in expression editor below.   Standard Sequence: Go to sequences in project Select Standard Sequence option which is default. We can use it in mappings for… Read More Sequences in ODI 12c

How to Uninstall/De-install OBIEE 12c in linux

How to uninstall OBIEE 12c in Linux. Drop RCU Schemas. De-install software. Delete the Oracle Home Directory. Delete Domain and Application Data. Drop RCU Schemas. Go to RCU file which is placed in below installed folder. <Middleware_home>/oracle_common/bin Run the command ./rcu Click on next and select Drop Repository. Click on Next. Enter details. Click on… Read More How to Uninstall/De-install OBIEE 12c in linux

Table function Component or pipeline functions in ODI 12c.

Purpose: We can use it as dynamic virtual table for staging. Advantage of table function is performance and memory. Pre-requisites: ODI 12c Oracle database KM: Default (IKM and LKM). IKM: IKM Oracle Insert.GLOBAL RKM: Default Components : TABLE FUNCTION, EXPRESSION Source Table: Source table is PIPELINED table function. Expected results: Calendar data for once year.… Read More Table function Component or pipeline functions in ODI 12c.

Set Component/Transformation in ODI 12c

Purpose: It behaves like SQL set operators (union, Minus, Intersect and except).UNION is chosen by default. Pre-requisites: ODI 12c Oracle database KM: Default (IKM and LKM). IKM: IKM Oracle Insert.GLOBAL LKM: LKM Oracle to Oracle Pull (DB Link) RKM: Default Components : SET Source Table: CREATE TABLE “SRC_SET_UNION_EMP_01” (           “EMPLOYEE_ID” NUMBER(6,0), “FIRST_NAME” VARCHAR2(20 BYTE), “LAST_NAME” VARCHAR2(25… Read More Set Component/Transformation in ODI 12c