Cognos Data Manager Condition Node is only available in Cognos Data Manager Job Stream. It is used to conditionally handle the flow of ETL inside a Job Stream. For example consider below scenario.
Scenario: You have to create an ETL to load datawarehouse for a food store. This food store is operational in different countries (let’s say India, United Kingdom) and having different set of columns in customer order table. In your ETL code you have 2 different builds one for each country (let’s say Build_India and Build_UK) to load data in order fact table. Now you have to execute Build_India when your ETL is executed for India and Build_UK when your ETL is run for United Kingdom. To handle this scenario we are going to use Condition Node. Assuming our country related information is stored in $Country. Follow below steps to add a condition node inside a Job Stream.
What happens here? When your job stream execute it execute condition node. Condition node having if and else statement to handle the flow of ETL. If $Country Contains India than Build_India is execute. If $Country not contains India than Build_UK is going to execute. Now you can ask another question. What if my Country is China than also Build_UK is going to execute. Yes your are correct, now this exercise for you to add another condition node between your first condition node and Build_UK. Please share your code here.
Still facing any issue feel free to post a comment.
Please login to post your valuable comments.
Get the latest vLemonn news first