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 |
What are the main features of datastage?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
How a server job can be converted to a parallel job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How can you write parallel routines in datastage PX?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
explain unit testing,systemtesting,integrated testing
How do u call shellscript/Batch file from DS?
source contains 2 columns comes to target 4 columns how
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
Difference in the implementation of lookup and join stages,in joining two tables?