Answer / hanug

We use parameters to reuse the job multiple times by
passing different values to the job parameters.

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?

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

How do you schedule or monitoring the job?

0 Answers  

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

What are stage variables, derivations and constants?

0 Answers  

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---