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
Cross-Database Joins Tableau Mobile for Android Device-Specific Dashboards Global Cross-Database Filters Clustering Custom Regions Web Authoring Data-Source Analytics Connectors Mobile Device Management Checkout for details: https://www.tableau.com/about/blog/2016/4/10-reasons-join-tableau-10-beta-53165 Thanks
User functions can be used for reduce the complexity of code in mapping/procedures. To avoid redundancy in mappings. Re-usability and sharing code to other mappings Scope: Global Project Used in: mapping Procedure Expressions Filter component Joiner component Source table: Aim: Create trim user function for all mapping,that is for project level. Results : Procedure: Create source… Read More User Functions 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 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
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.
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