Why we use parameters instead of hard code in datastage.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Data Stage?

647


What are the areas of application?

664


Can you explain how could anyone drop the index before loading the data in target in datastage?

901


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3505


What are the types of jobs we have in datastage?

676






How to implement complex jobs in data stage?

621


What is the use of datastage designer?

642


On which Dimension Table you implemented SCD Type in your Project

1586


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

639


How complex jobs are implemented in datstage to improve performance?

604


What are stage variables?

641


Where the datastage stored his repository?

620


What is a merge?

674


Could anyone give brief explanation bout datastage admin

1975


What all are the different way to run a job?

645