Is there a way for me to use a transformation like this to use as an inner query in 'table input 4' like using 'insert data from the step' or 'execute sql script'? If not, is my only option using the whole query in the table input step?
Is there a step in Pentaho Spoon to use a transformation as inner query?
216 Views Asked by Alper At
0
There are 0 best solutions below
Related Questions in PENTAHO-SPOON
- Expired time for acquiring lock pentaho
- Dynimically load table text,Xml values into ETL Pentaho JOB
- Pentaho job FTP is not picking up file from remote location
- How to execute sql script in pentaho and store in xml.
- How to implement an add if not available in the database in Pentaho?
- How to launch two jobs simultaneously after the execution of one Job in Pentaho
- Pentaho Spoon Value Mapping
- Continue stream based on result of a DB query
- Make a DB INSERT based on Text File Input metadata
- Job is not failing in pentaho which i read it through VFS when the file is not available in S3
- Getting result from SQL Server Stored Procedure
- why this if else statement not working - kettle javascript
- Spark Submit giving error in Pentaho Spoon
- Pentaho kettle value conversion
- why the execute sql script is not working in kettle
Related Questions in PENTAHO-DATA-INTEGRATION
- How to launch two jobs simultaneously after the execution of one Job in Pentaho
- How to retrieve User or Admin Images??how to clear that CDA cache memory?
- Continue stream based on result of a DB query
- Make a DB INSERT based on Text File Input metadata
- Getting result from SQL Server Stored Procedure
- Kettle database lookup case insensitive
- PDI Metadata Injection for JSON Input
- Remove duplicated row from 2 tables in different database
- Using PostgreSQL with Pentaho
- User defined JSON input to Expected JSON output using PDI Metadata Injection
- why the execute sql script is not working in kettle
- lookup_Pentaho data Integration
- PDI transformation does not send messages to Kafka server
- How to format XML using Pentaho
- How to Read a multi nested JSON file with Pentaho Spoon 6 JSON Input
Related Questions in INNER-QUERY
- Inner query not throwing error in postgres
- Does Vertica DBD takes Inner Queries into account while configuring Projections?
- How to implement sub-query in Microstratergy?
- MySQL Sum + Inner Query in same table
- Improve SQL query by replacing inner query
- Error in inner query , where as inner query independently when run dont generate error
- Is there a step in Pentaho Spoon to use a transformation as inner query?
- How to express "either the single resulting record or NULL", without an inner-query LIMIT?
- IN operator with Inner query SQL
- 4D SQL (v15.6): mix of JOINS + WITH clause + INNER queries on FROM, SELECT
- Difference between two identical tables in mysql
- How do I handle exception while converting date
- Update field value of a table with max value of two fields of two other tables
- How to find Last record in group
- inner query in laravel 5.3 query builder
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?