Generated random value (uuid) in Pentaho as Column value?
I have a transformation in Pentaho which looks like this:
This transformation populates a table PRO_T_TICKETS in PostgreSQL.
And this table primary key is named OID and has the uuid data type.
Here is a snip of my Database Join query:
I want to use the generated random value by Pentaho as column value for OID.
My question is where should I place the step "Generate random value (OID)" in my Pentaho job flow and what editing should I make in my db join so the join selects this generated uuid as its value?
Get the data flow as you want except it has no OID. Make the flow to cross the Generate random value and name it OID. That should be the flow you are looking for.
Also, be kind for us, clean you example and remove all what is not mandatory to understand the problem (like sort, normalizer and the kind of sort).
- checking java date with postgresql timestamp without timezone
- Enable debugging of postgresql functions on database inside a docker container using pgAdmin
- TypeORM: Custom Many To Many Relationship
- Delete json object from jsonb type column based on key of json object in postgresql
- Docker runs PostgreSQL in "trust" mode
- How to fix Postgres error "operator does not exist" using pgvector
- Rails 4 scope NOTNULL refactor
- postgreSQL index not found why?
- Select on self-referencing table where all chains meet a condition
- How to successfully save data to another database column in postgresql using jetpack compose?
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Variables in looping condition in a postgreSQL while loop
- SQL query for returning rows with only certain values in list but not others?
- How to insert data into a code-first database with a SQL script?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- Pyspark JDBC read with partitions
- Quarkus dev postgresql container not shutting down with quarkus
- Permission issue with PostgreSQL in docker container
- Starting application development using Docker or configuring Docker during development?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- postgresql - replace all instances of a string within text field
- migrate data from MS SQL to PostgreSQL?
- How to change the select output delimeter from '|' to ',' on Postgres through command line?
- Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
- Psycopg2: how to deal with special characters in password?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- Postgres container doesn't start