1.new record it will insert but changes of natural key is not present in tage

1.new record it will insert but changes of natural key
is not present in taget i want
to update (here key is composite natural key )can any one
help this to explan how to do

Question Posted / srilakshmi986

1 Answers
2177 Views
IBM, I also Faced
E-Mail Answers

1.new record it will insert but changes of natural key is not present in taget i want to update..

Answer / Satish Chandra Singh

In Data Stage, if you need to update a record with a composite natural key that does not exist in the target, you can use the UPDATE_MATCH statement. This allows you to match on multiple columns and perform updates even when the natural key is not present exactly as it was previously. Here's an example:

Assuming your source dataset has a composite natural key (Column1, Column2) and target dataset has the same structure.

```sql
UPDATE_MATCH TargetDataset
SET
Column1 = SourceDataset.Column1,
Column2 = SourceDataset.Column2,
OtherColumns = SourceDataset.OtherColumns
FROM SourceDataset
WHERE Column1 = TargetDataset.Column1 AND Column2 = TargetDataset.Column2;
```
This statement will match records based on the composite natural key and update them if they exist in the target dataset.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer