* What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are the different types of lookups available in DataStage?

Questions by debasis_mohanty   answers by debasis_mohanty

Showing Answers 1 - 2 of 2 Answers

Venkat

  • May 22nd, 2006
 

Constraints are used to check for a condition and filter the data. Example: Cust_Id<>0 is set as a constraint and it means and only those records meeting this will be processed further.

Derivation is a method of deriving the fields, for example if you need to get some SUM,AVG etc.

  Was this answer useful?  Yes

venkat

  • May 22nd, 2006
 

Constraints are condition and once meeting those records will be processed further. Example process all records where cust_id<>0.

Derivations are derived expressions.for example I want to do a SUM of Salary or Calculate Interest rate etc

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions