Why we use parameters instead of hard code in datastage.
- 2 Answers
- 6923 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hanug
We use parameters to reuse the job multiple times by
passing different values to the job parameters.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / nish
hard coding is a very bad practice.
You will face troubles once you deploy to production environment and need to make changes.
Instead if you parameteris and just make the change in original it will automatically update.
This is similar to your ATM card and pin. even if you change/update your pin the card will work.
If pin is hardcoded to the card and you need to change pin, then you need to get a new card everytime you want to change pin.
Does that make sense?
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain ibm infosphere information server and highlight its main features?
How many Nodes configuration file you used in your last project?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
How do you load dimension data and fact data? Which is first
What is quality stage?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
What are stage variables, derivations and constants?
can we half project in parallel jobs and half project in server jobs?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What are the functionalities of link partitioner and link collector?
Teradata 
