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 Continue Reading
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 Continue Reading
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. Continue Reading
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 Continue Reading
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 Continue Reading
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 Continue Reading
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 Continue Reading
CREATE SQL SERVER INSTANCE IN AWS
Today, i will discuss regarding the sql server instance creation in AWS. First of all, login to your AWS account. Go to services -> RDS. Below image will appear on Continue Reading
HOW TO GENERATE ACCESS AND SECRET KEY IN AWS
Today, i will discuss about “how to generate Access and Secret key in AWS”. First, go to “My Account credentails”. See the below image for the same. Then Go Continue Reading
HOW TO CREATE A S3 BUCKET IN AWS
Today i will discuss about “How to Create the S3 bucket in AWS”. Login to AWS account. Go to S3. Click on “create bucket”. See the below image for the Continue Reading