Our team has a postgres DB which has a lot of data, to which Pega (Decisioning Platform) is connected. But Pega receives unwanted attributes, data and irrelevant information from this DB which is impacting its performance and efficiency. I'm planning to implement a staging DB(another postgres DB) with only required tables, data and attributes for Pega. Could you please suggest a best possible solution to load data from Postgres DB to this staging DB on a regular basis. I guess one best option would be ETL. Are there any other easy efficient ways of doing the same.
Data from Postgres Production DB to a postgres staging database
55 Views Asked by Anjali Raj At
0
There are 0 best solutions below
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in LOAD
- How to configure api http request with load testing
- Laravel 11 Staudenmeir BelongsToThrough Undefined Relationship
- Context Deadline exceeded and WebSocket Url timeout issue
- WebIX Loading Icon Spin until method is completed
- Performance of loading Time and influxdb
- Load Testing, Performance Testing , Jmeter
- Feature Request: Enumeration of issues with Workspace Trust "Do you trust the authors of the file in this folder?"
- How to abort a fetch request when it is made using load method of loaders.gl
- Authorisation code Flow with PKCE using Jmeter
- When will SQLite through SQLITE_IOERR_SHMMAP error? SQLite C library
- Error invoking remote method 'DB_CONNECT': Error: Host 'x.x.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
- Call a function on every resize and load
- GCP Failed load job, how to get the source json
- Dropdown Not Populating with Dynamic Data in React Component
- How to fix Android studio Unable to load class 'org.gradle.initialization.BuildCancellationToken' error
Related Questions in SCHEDULING
- Problem on CPU scheduling algorithms in OS
- Building a School Schedule Generator
- What are the motivating use-cases for each of Linux's SCHED_* scheduling algorithms?
- How to Schedule a Vertex AI Notebook Execution with Custom Environment Including Scripts and Config Files?
- Round Robin Implementation with Different Arrival Time
- Airflow: Find a DAG schedule Dataset URIs from DagBag
- Swiss Scheduling System for Ping-Pong league
- Only allow intervals to be produced on machines during shifts cp-sat or-tools
- what's the exact performance cost of context switch within the same thread? (memory access -> page fault -> memory access again)
- Scheduled method won't execute when I make a Spring bean to Application Scope
- Error while attempting to Implement Preemptive SJF in C
- How can we model the process scheduling mechanism in Linux using queueing theory models?
- OptaPlanner - use groupBy for avoidOvertime but only on the Resource creating the overtime
- Dynamic Flowfile Transfer Scheduling Using Quartz in NiFi Processors
- Setting up a Cron Job to Trigger on the Y-th Day Every Month, Handling Non-Existent Dates
Related Questions in DATA-TRANSFER
- Python PyUSB NotImplemented Error dev.write(), dev.read(), dev.ctrl_transfer()
- Thunderbird: Get Subject dynamically in HTML Signature
- Transfer linked list values from one linked list to another in C
- Data Transfer From Table to Table in BigQuery
- How can I access errors[] collection after transfer failed?
- How to copy data to identical Postgres table with foreign key using Delphi?
- dataTransfer.dropEffect doesn't work in dragenter event handler
- Empty file when uploaded via Playwright test
- error on uploading file with playwright js
- SPI Mode 2 (Clock Polarity: 1, Clock Phase: 0) is not working when I am interfacing ADS1293 with ESP32 Wroom 32
- Is it possible to transfer an in-game item to another player without cloning?
- Google Apps Script. Transfer data from current active sheet to another by URL (on Edit event)
- Data from Postgres Production DB to a postgres staging database
- How can I set custom drag data in Safari without breaking some native drag drop behavior?
- HDMI input in laptop through USB 3.1 type c or USB A 3.0
Related Questions in PEGA
- Implementation of Pega DX API in Android
- Performance testing PEGA application
- Data from Postgres Production DB to a postgres staging database
- pega-web-tomcat container not starting with | Problem during method invocation (doPostInner)
- I need to find the right age of the applicant using data transforms in pega
- Is there any pega function that should vanish the present appearing button and shows another button?
- I have following policy types how will be the RUTA script for it, by using which i will be able to extract complete policy number
- How do we add a "RS" symbol before the user input value? in PEGA
- setting up Validations for properties in a process category, Facing error while the code attached below
- This question regarding pega, I need to validate age property on client side,
- How to delete a table row from UI (Delete Button at the end of the each row) by primary key using activity in PEGA
- Failure opening rule instance pega
- Pega Unit Testing
- Which function to use to validate - input year should not be greater than the current year
- How I remove the comma separator in integer edit input?
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?