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
Month: May 2018
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…
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 your screen. Select SQL server as database Engine. Check the checkbox on “Only enable options for RDS Free Usage Tier” if you are using free Tier Account. Once you check the checkbox, it will automatically choose the option “Sql Server Express Edition”.If you are working on a project, choose the option as per the client requirements. See the below image…
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 to Access keys(Access key ID and secret access key). Then click on “Generate Access key”. Once you click on this button,”rootkey.csv” will get generated which will have Access key and Secret key.
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 same. Once you click on “create bucket“, it will ask for bucket name. Enter the bucket name(I created the bucket with name “s3-tech”) and click on Next. Then again click on Next.(As I am using free tier Account so few of functionalities are disabled). Then choose the value “Do not grant public read access to this bucket” for “Manage public permission”…
S3 FILE OUTPUT IN PENTAHO
Today i will share my experience on S3 file output component in Pentaho. This component is used when you want to create a file(with data in it) in S3 bucket. Below is the ETL code for the same. In above transformation , CSV file input and S3 file output component are used. In this code, I am just copying the data from a file which is present in my local Machine to the S3 bucket(s3-techie as mentioned in my last blog). In S3 output file, mention the values for S3…