why we use parameters instead of hard code in datastage
Answers were Sorted based on User's Feedback
Answer / ashok
not only security,for suppose i want to give another values
go to design and change the values it is not convinent for
user instead of this using parameters giving values at
runtime is flexible
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / shar
we use parameters for flexibility,re-usability in job design, values hard coding is a bad habit and bad practice.
lets say u have 20 fields and u have to pass them every time as and when data processing demands. Then every time going into the job and modifying the values is an unprofessional way and we sometime commit typographical errors.
instead of that use job parameters for reusability and we can use them any where flexibly depends on the parameters created at job level or project level.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kiran
Hi Ashok..,
What ever Values u change run time(dynamically) which
purpose is called security.
Thanks
Kiran
8055902709
| Is This Answer Correct ? | 1 Yes | 4 No |
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
What are constraints and derivations?
What is use Array size in datastage
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
How do you load 10 different sources with 10 different layouts to 10 different tables?
Can you define merge?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between operational data stage (ods) and data warehouse?
Difference in the implementation of lookup and join stages,in joining two tables?
Describe the architecture of datastage?