What is the difference between the SubQuery and Corelated SubQuery ?
Answer : The inner query is executed only once...
What is the Difference between join and union ?
Answer : The union operator combines the results of two or more queries into a single result set...
What is the SQLCode -501 ?
Answer : sqlcode -501 pops up to show...
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?
Answer : The HAVING clause sets conditions on the GROUP BY...
Difference between Clustered and Non-clustered index ?
Answer : Cluster index: Clustered index will be created...
What is an Index ?
Answer : Index is a database object which improves the efficiency of the query...
How to find the second highest salary from emp table ?
Answer : Select max(sal)...
How to adding the page footer fields in pentaho ?
Answer : The page footer tab is used to present various attributes and functions.
How to perform database join with PDI (Pentaho Data Integration) ?
Answer : PDI supports combination of two tables form the same database using a ‘Table Input’ method performing the join in...
What are the types of Data Integration Jobs ?
Answer : Transformation Jobs,Provisioning Jobs,Hybrid Jobs
What are the benefits of Data Integration ?
Answer : The biggest benefit is that integrating data improves consistency and reduces conflicting and erratic data from the...
What are the steps for PDI Transformation ?
Answer : Pentaho Data Integration (PDI), it is also called as Kettle. Pentaho responsible for the Extract, Transform and...
What is the importance of metadata in pentaho ?
Answer : Metadata model in pentaho gives an encapsulation about the physical definitions.....
What is PDI Architecture ?
Answer : All of the tools. PDI / Kettle is sometimes used to mean Spoon.
What is Pentaho Dashboard ?
Answer : Dashboards are the group of different information objects on single page such as tables, diagrams and textual...
What is Pentaho-chart Report ?
Answer : A chart is defined as graphical representation of data or otherwise called a graph.
What is Pentaho Report types ?
Answer : Data to be used from transactions.....
What is Pentaho Reporting Evaluation ?
Answer : Pentaho Reporting evaluation is a package of its reporting activities......
How to Install PDI Using Wizard
Answer : The wizard used to install PDI. PDI software install by wizard.....
What are the features of Pentaho ?
Answer : Pentaho is ability for building Advanced Reporting Algorithms despite of their input and output data format.
