Answer / subhash

In the transformer stage's link constraints:
write below constraint
@INROWNUM <> 1 And @INROWNUM <> LastRow()
then you will get the desired out put.

Answer / reddymkl.dwh

If data is fetching from SeqFile, we can do this way also

Use Filter Command

Sed '1d;$d' FileName
It will delete frist and last records.

U will get answer, Plz correct me if am wrong....

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

What is a quality stage in datastage tool?

0 Answers  

---

how to add a new records into source?

0 Answers  

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

convert yyyy mm dd to dd mm yyyy?

4 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

why we use hash file for lookup?

5 Answers  

---