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
Explain usage analysis in datastage?
EXPLAIN SCD
Differentiate between validated and Compiled in the Datastage?
Is the value of staging variable stored temporarily or permanently?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Explain how a source file is populated?
Differentiate between Join, Merge and Lookup stage?
What are the main features of datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Give an idea of system variables.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
root tree will find which is server job and which is parallel job?
Distinguish between informatica & datastage. Which one would you choose and why?
What is data partitioning?
Can you explain engine tier in information server?