why we use parameters instead of hard code in datastage

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between an operational datastage and a data warehouse?

853


What is the difference between in process and inter process?

892


What are the types of views in datastage director?

1521


how do u catch bad rows from OCI stage? And what CLI stands for?

2528


how many rows sorted in sort stage by default in server jobs

3739


On which interface you will be working as a developer?

825


Lookup constraints

1033


What is the difference between passive stage and active stage?

1069


Differentiate between data file and descriptor file?

804


Explain Quality stage?

895


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1976


AGGREGATOR default datatype

1135


What are the functionalities of link collector?

839


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2499


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3946