Answer Posted / madhavareddy

seqstage->sortstage->transformerstage->removedupicatestage->targetdataset

sortstage->put chagekeycolum=true

transformer -> stagevariable->sv1 if change key colum =1 then in.column else sv1::in.column

in derivation colum give ->sv1

then in remove duplicate stage keep last record option

then you will get desired output

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3268

---

What is the difference between passive stage and active stage?

1417

---

Define APT_CONFIG in Datastage?

1025

---

What are the different common services in datastage?

1216

---

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

1092

---

Can you filter data in hashed file?

3727

---

What is the difference between odbc and drs stage?

1047

---

how to export or import the jobs in .ISX file

1136

---

Difference between data warehousing and olap?

1044

---

Name the command line functions to import and export the DS jobs?

1094

---

What is the process of killing a job in datastage?

964

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2557

---

How do you import and export the datastage jobs?

1113

---

Define repository tables in datastage?

1103

---

How to implement complex jobs in data stage?

1055

---