Answer Posted / shivam

For this we can use Head and tail stages from development
and debug stages. Suppose we have 10 records,And we are
asked to pick 2nd to 9th record in the output, then go for
the following:
Sequential file--->Head stage--->Tail stage---->Data set

In the Head stage properties mention the number of records
you want to extract 9 records, this way you will get 1st to
9th records(top 9) extracted. Now, in Tail stage properties
mention number of records to extract 8, this way you get
last 8 records out of top 9 i.e 2nd to 9th. Finally as an
output you will find records 1st and 10th dropped.

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3852

---

What are the features of datastage flow designer?

1099

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3810

---

What are some different alternative commands associated with "dsjob"?

1213

---

What is the difference between account and directory options ?

1234

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2326

---

Explain ibm infosphere information server and highlight its main features?

1140

---

how can we create rank using datastage?what is the meaning of rank?

8856

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1279

---

How the ipc stage work?

1170

---

What is a folder? Difference types of stages?

1241

---

How many areas for files does datastage have?

1218

---

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

1548

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1208

---

options available in sequence job to run,validate?

1363

---