data-migrationtalend
How to migrate data from one table to different tables using conditions in TALEND
I have a requirement where i need to migrate data from one table of oracle DB to different tables based on condition like if tableA contains value A in one column then insert it into tableA else insert it into tableB. Can we do this using TALEND. Someone please guide me.
Solution
Yes you can do conditional load in Talend. and based on your scenario you can use filter expression of Talend to do it. check screen for more details.
add two oracle output for loading into table A and table B like below screen.
- What is the exact location of MySQL database tables in XAMPP folder?
- Can't execute queries until end of atomic block in my data migration on django 1.7
- SQL Server String or binary data would be truncated
- Run Flyway Migration Asynchronously
- Data Migration Services - Cannot connect to target
- How to check that all shards are moved from a specific elasticsearch node?
- Did I write data migration for data type change in a correct way?
- AWS DMS S3 Target Validation Stuck in "Records Pending"
- How to migrate data from MongoDB to SQL-Server?
- How do I move a redis database from one server to another?
- How can I export data from cosmosdb to .json file
- Matrix Synapse and Riot migration
- How can I migrate my flutter coded and firebase hosted app to a no-code platform?
- Import multiple zip files data through Azure DevOps pipeline
- Enclosing a password which contains special characters with curly braces does not work
- How to get Guid from SqlDataReader uniqueidentifier
- Export Entire Data from Dynamo DB table to S3
- spring batch RepositoryItemWriter doesnt write data to database
- Spring batch using two data Sources
- Does liquibase support data migration from one database to another
- Spring batch processing for data migration of a workflow
- Azure Data Factory, table storage copy Binary data results in System.Byte[] output
- How to create *working* data migration using relation to custom User in Django?
- Rails - Skip data_migrations in specific environments
- Is there any reason not to move data from one table to another using a Flyway SQL script?
- SQL Server migration from denormalized to normalized table causing performance issues
- How to set database migration strategy to manual in Keycloak 18
- Realm migrations in Swift
- Repartitioning existing table online
- How do I escape database table and column names for PostgreSQL in VBA?