I am inserting data into target table on daily basis(once in a day) from source table. I want to insert only new records into target table to avoid duplicate. I want to keep old record in target table if data changes in one field, It should insert new record and expire old record in Target table. I want to keep old record as well. I think this problem is related to CDC. I am using only Teradata, no other third party tools. Could you please help me to solve this problem using SQL?
Change Data Capture(CDC) in teradata
1.4k Views Asked by Anuj Mishra At
0
There are 0 best solutions below
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in TERADATA
- Declaring field to use Unicode UTF-16
- Variable set by user when running query, Teradata
- Cannot nest aggregate operations
- Can't set column name equal to variable which is determined by the user
- TERADATA - How to split a character column and keep the last token?
- All users can access DBC tables by default
- teradata get rid of hardcoded financial year date
- regex in teradata, how to pass two values in
- What is ROWS UNBOUNDED PRECEDING used for in Teradata?
- What is the equivalent of "%[^ ]%" to Teradata?
- SQL Teradata evaluation order of case when then else
- Trying to get connecting Dabase Name using java
- Teradata Convert DATE to midnight
- Sqoop Incremental Import and CURRENT_TIMESTAMP
- Subtract record from previous record within same column in teradata
Related Questions in ORACLE-CDC
- Is there any other option (resource) for storing data except file or DB?
- Informatica CDC Mapping: Group Source is fetching records Slowly
- How to provision Oracle-to-MySQL replication using synchronous CDC with no downtime?
- Oracle CDC source connector Date based column is not taking sysdate value in kafka topic
- Change data capture (cdc) for Oracle edw
- why to use kafka to store cdc data instead directly consume by spark?
- Unable to parse schemas received by schema registry while tracking oracle database changes
- Overcome CDC drawback
- OracleDB open source way to ingest CDC
- Data Migration to Amazon S3 buckets
- Merge data logic for CDC snowflake
- Issue with merge task for CDC snowflake using stream and task
- Debezium CDC connector says no ocijdbc11 in java.library.path
- How to Implement Resume from Last Checkpoint for Powerexchange CDC sessions?
- Change Data Capture(CDC) in teradata
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?