in Technology by
Why update strategy and union transformations are Active? Explain with examples.

1 Answer

0 votes
by
  1. The Update Strategy changes the row types. It can assign the row types based on the expression created to evaluate the rows. Like IIF (ISNULL (CUST_DIM_KEY), DD_INSERT, DD_UPDATE). This expression, changes the row types to Insert for which the CUST_DIM_KEY is NULL and to Update for which the CUST_DIM_KEY is not null.
  2. The Update Strategy can reject the rows. Thereby with proper configuration, we can also filter out some rows. Hence, sometimes, the number of input rows, may not be equal to number of output rows.

Like IIF (IISNULL (CUST_DIM_KEY), DD_INSERT,

IIF (SRC_CUST_ID! =TGT_CUST_ID), DD_UPDATE, DD_REJECT))

Here we are checking if CUST_DIM_KEY is not null then if SRC_CUST_ID is equal to the TGT_CUST_ID. If they are equal, then we do not take any action on those rows; they are getting rejected.

Union Transformation

In union transformation, though the total number of rows passing into the Union is the same as the total number of rows passing out of it, the positions of the rows are not preserved, i.e. row number 1 from input stream 1 might not be row number 1 in the output stream. Union does not even guarantee that the output is repeatable. Hence it is an Active Transformation.

Related questions

0 votes
    How do you update the records with or without using Update Strategy?...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    Can anyone tell me why you need a Digital Marketing strategy? Select the correct answer from above options...
asked Jan 10, 2022 in Education by JackTerrance
0 votes
    What is the exact difference between grades of organization and symmetry? Explain with examples. Select ... proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
    Explain with suitable examples, the relationship between weather forecasting and disaster management. Select the ... by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
    Explain the following terms with suitable examples : : a . a l c o s o l a , b . A e o r s o l b , c . H y d r o s o l c Select the correct answer from above options...
asked Jan 2, 2022 in Education by JackTerrance
0 votes
    Explain with suitable examples, the care to be taken when using the methods of transporting patients. ... proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
    What are the different transformations where you can use a SQL override?...
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    What are the different ways to filter rows using Informatica transformations?...
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    What are the features that can be accomplished using affine transformations? (a) arbitrary rotation (b) scaling (c) ... d) all of the mentioned Please answer the above question....
asked Sep 4, 2022 in Education by JackTerrance
0 votes
    what are affine transformations? (a) addition of bias term (-1) which results in arbitrary rotation, scaling, ... ) none of the mentioned Please answer the above question....
asked Sep 4, 2022 in Education by JackTerrance
0 votes
    The cipher generated by combining multiple transformations to enhance the security of the resultant cipher is __________ ... ciphers (3)Transformation ciphers (4)Product ciphers...
asked Mar 19, 2021 in Technology by JackTerrance
0 votes
    Why is sorter an active transformation?...
asked Mar 26, 2021 in Technology by JackTerrance
0 votes
    What is the features that cannot be accomplished earlier without affine transformations? (a) arbitrary rotation (b) ... all of the mentioned Please answer the above question....
asked Sep 4, 2022 in Education by JackTerrance
0 votes
    This may be a silly question to a graphics guru (which I am not), but what's the difference ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 11, 2022 in Education by JackTerrance
...