Why we use parameters instead of hard code in datastage.
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 |
How you can fix the truncated data error in datastage?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What are the partition techniques available in your last project?
How to Convert the columns into rows?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
Why we need datasets ratherthan sequential files?
How to reverse the string using SQL?
which unix commands mostly used in datastage
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
How will you move hashed file from one location to another location?