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 |
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
How many Key we can define in remove duplicate stage?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
How can we run same job in 1 day 2 times
how can i abort the job if i get more than 100 errors in job log?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Have you used Unstructured data?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
how many types of sorting the data in data stage?
what is the use of surogate key in datastage
How to implement complex jobs in data stage?