Scribd
Upload
9 views1 page

Update Strategy Exercise

The document outlines tasks for NiC IT Academy related to ETL processes, including updating a target table without using update strategy and creating an ETL mapping for record deletion. It also mentions implementing update strategy logic for Slowly Changing Dimension (SCD) type-1 using the MD5 function. Additional contact information and resources for online training are provided.

Uploaded by

amit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

Update Strategy Exercise

The document outlines tasks for NiC IT Academy related to ETL processes, including updating a target table without using update strategy and creating an ETL mapping for record deletion. It also mentions implementing update strategy logic for Slowly Changing Dimension (SCD) type-1 using the MD5 function. Additional contact information and resources for online training are provided.

Uploaded by

amit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

NiC IT Academy

1. Update the target table without using update strategy

Hint: session level properties:

Update strategy for target (Update as Update)

Update strategy for target (Update as Insert)

Update strategy for target (Update else Insert)

Or try with Dynamic lookup cache

2. Create an ETL mapping If I delete a record in the source, the corresponding record in the
target will also be deleted.
3. Create update strategy logic for SCD type -1 with MD5 function.

Hint: Returns the MD5 hash value of the input value as char.

NiC IT Academy +91 7010080468(WhatsApp)


[Link] nicitacademy@[Link]
Contact for Online Training! Watch my YouTube for more tutorials.

You might also like