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.

which r the connectors used in san?

2188

---

What is the difference between passive stage and active stage?

1539

---

What are the types of containers and how to create them?

980

---

how many rows sorted in sort stage by default in server jobs

3997

---

How do u convert the columns to rows in datastage?

1194

---

Can you explain tagbatch restructure operator?

1178

---

Difference between sequential file and data set?

1205

---

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

3759

---

How we can covert server job to a parallel job?

1147

---

How and where you used hash file?

1174

---

What is the flow of loading data into fact & dimensional tables?

1063

---

What are the difference types of stages?

1216

---

What is the difference between the local container and shared container?

1103

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

what is the use of surogate key in datastage

2310

---