Answer / ankit gosain

Hi All,

Open you Sequential File then
Output>Properties>Options>RowNumberColum and name the
column as SeqNumber.
And don't forget to add SeqNumber to the Column Definitions.
Otherwise, if RCP is disabled, DataStage will drop that
column.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Answer / revanth

Use the row number column in options of sequential file.

Answer / suneel

Hi Ankit,

That will be fine but here one thing
At what place you are disable the RCP.

Thanks

How can we achive parallelism

1 Answers   CTS,

---

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

Explain connectivity between datastage with datasources?

0 Answers  

---

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,

---

---

What is ds designer?

0 Answers  

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

---

What is the process of killing a job in datastage?

0 Answers  

---

difference between function and procedure...

1 Answers   IBM,

---