Today, i will discuss about how to monitor Sessions and check what all queries executed in pl/sql Sessions. First, In order to Monitor Sessions which are active /inactive in particular Schema in pl/sql developer tool, Go to Tools->Monitor Sessions. See the below Screen Shot for the same. Second, In order to see what all queries executed in particular Session , go to View -> SQL History. See the below image for the same.
Year: 2018
MERGE ROWS(DIFF) IN PENTAHO
Today, i will discuss about the component “Merge Rows(Diff)” in Pentaho. See the below transformation for the same. Before we start discussion on Merge Rows, always remember to sort the data on common columns from both streams before you add Merge row component. Otherwise results will not be correct. Here , i considered two CSV files which has data of employees. See the below images for the same. Here MAR-SAL.csv is mapped to Reference rows origin field in Merge rows component and FEB-SAL.csv is mapped to Compare rows origin field in Merge…
HOW TO UPGRADE/UPDATE THE PENTAHO PLUGINS
Today, i will discuss about how to upgrade/update the Pentaho plugins. Pentaho is the Best ETL tool in my understanding and its open source version is very effective in a way that many organizations uses the open source version in production environment as well. It has several plugins to connect to various third-party services. Some time you need to upgrade those plugins without changing the Pentaho version. There might be multiple reasons for that but primarily it is due to some bug or lack of feature in current plugin. HOW TO UPGRADE/UPDATE…
DERIVED VARIABLES IN PENTAHO
Today, i will discuss about the Derived variables in Pentaho. The term “Derived Variables” means variable name or variable value derived from a particular variable or its value. In order to demonstrate that i have designed an ETL job for the same. See the below image for the same. In this transformation, i used get system info, where i defined one variable “date_value” with value as system date (fixed). After this component, i added Java script component where i created new more variables and value is derived from date_value variable.…
GET COLUMN NAMES ON WHICH INDEX IS CREATED IN ORACLE
Today, i will share the query which will give the column names along with table name on which index is created.Below is the Query for the same. select a.index_name,a.table_name,b.column_name from all_indexes a, all_ind_columns b where a.table_name=b.table_name and a.index_name=b.index_name and a.uniqueness=’UNIQUE’ and a.table_name in <LLIST OF TABLE NAMES> Query to give column names which are not null in the table. select table_name,column_name from all_tab_columns where table_name like ‘%ABC%’ and NULLABLE=’N’ and owner=<SCHEMA_NAME> order by table_name
INTERVIEW QUESTIONS IN PENTAHO SET-2
Today, i will discuss about the interview Questions on Pentaho. In my previous blog, I have share 15 Interview question. You can go through those as well using below link. interview Questions on Pentaho Below are the new set of Interview Questions on Pentaho. 1. What is Carte in Pentaho. In what all scenarios , we can avail Carte services. 2. How can we dynamically split value into multiple Variables. 3. What is AEL (Adaptive execution Layer) in Pentaho. 4. How can we change the User interface of Pentaho BI…
DEFECT METRICS
Today we will look at some of the Defect metrics which can help in effectively managing the project and identifying the pain areas. Defect Metrics drive information from defects raised with a view to help in decision making. Few defect metrics for effective project management are: Defect Density Defect Cause Distribution Defect Detection against Closure Percentage of Defects Rejected Percentage of Defects Reopened Defect Density: Defect Density is the number of confirmed defects detected in software/component during a defined period of development/operation divided by the size of the software/component. Defect Density…
HOW TO GET FILENAMES PRESENT INSIDE THE ZIP FILE
Today, i will discuss about “How to get filenames present inside the zip file without unzipping it”. Here, “Get file names” component will be used. See the below image for the same. In Get File Names component, the value of file directory is set to zip://C:/data-integration/SALARIES.zip and wildcard is “.*“. Here the catch is “zip:” part . Click on show filenames.It will give you all file names which are present inside the zip file. See the below image for the same. Run the transformation and see the Pentaho logs. Write to…
DYNAMICALLY SPLIT FIELDS IN PENTAHO
Today, i will discuss about the split fields component usage based on the occurrence of delimiter. In last blog, we encountered that if occurrence of delimiter vary, then the split field component will not work effectively. In other words, alone split field component is sufficient to get the proper results. Please see the below image which demonstrate the dynamically using split field component based on the count of delimiter occurrence. Here, switch/case component and java expression is added. Below is the java script used to get the occurrence of delimiter.…
SPLIT FIELDS COMPONENT IN PENTAHO
Today, i will discuss about the “Split Fields” component in Pentaho. Split Fields component split the value of a variable into multiple variables based on delimiter.For example, consider a variable var1 having value a;b;c. Now i need to split into three different values a,b and c. In order to achieve this, use split Fields component in Pentaho with delimiter as “;”. See the below image for the same. Use Generate rows to generate one variable with value “a;b;c”. Then use the split Field component with delimiter as “;”. See the…