DataStage tips is now active on datastagetipsntricks.blogspot.com
Upsert method is nothing but, it combines both update and insert queries. So that we call it as Upsert method.Generally this upsert method is seen in oracle enterprise stage. Generally it is used for SCD_types validations.. Like whether the data is inserted or updated.
Upsert method is nothing but, it combines both update and insert queries. So that we call it as Upsert method.
ReplyDeleteGenerally this upsert method is seen in oracle enterprise stage.
Generally it is used for SCD_types validations.. Like whether the data is inserted or updated.