Cognos Data Manager Condition Node

Cognos Data Manager Condition Node

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.

  • Right Click on Job Stream in which you want to add condition node and click on Insert Node and select Condition Node.
  • Provide appropriate Business name and Description.
  • Click on Action tab and add below code. Assuming variable Country is define with data type char. Also is set inside job stream before its usage.

IF($Country='India')THEN
   RETURN TRUE;
ELSE
   RETURN FALSE;

  • Click on True tab and check the check box in front of "Build_India". Assume this build is available as per above mentioned scenario.
  • Click on False tab and check the check box in front of "Build_UK". Assume this build is available as per above mentioned scenario.

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.

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share