Given a nested list, write python code to flatten the list.Note: The input list will strictly have 2 levels, i.e. the list will be of the form [[1,2],[3,4]]. Inputs like [1,[2,3]] and [[1,[2,3],4],5] are not applicable. Nest_list = [[1,2,3],[4,5,6],[7,8,9]] #List to be flattenedflat_list = [] for i in range(len(Nest_list)): #Traversing through the main listfor j… Read More Nested to Flatten list
Consider that email IDs are supposed to be for the following format: Here, there are three conditions to keep in mind:1. The username can only contain characters 0-9, a-z and A-Z.2. The website name can contain only characters a-z3. The extension can have 2 or 3 alphabets(a-z). def checkmail(email):a =”@”c=”.”Res1 = email.find(a)Res2 = email.find(c)Part1 =… Read More Valid email ID 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
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
A Lookup is Selector component that returns data from a lookup flow being given a value from a driving flow. A lookup can be implemented in generated code either through a Left Outer Join or a nested Select statement. Default join is left outer on driving table. Pre-requisites: ODI 12c Oracle database KM: Default (IKM… Read More Lookup Component/Transformation in ODI 12c
Data Science and Business Intelligence 