how can you generate sequence number using only the sequential
file stage?

Answer Posted / 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 :)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1916


Where do you see different stages in the designer?

627


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

616


how to implement scd2 in datastage 7.5 with lookup stage

5122


Is possible to create skid in dim,fact tables?

2187






How to implement complex jobs in data stage?

612


What are the main differences you have observed between 7.x and 8.x version of datastage?

618


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1801


table actions available in oracle connector?

1086


What are the types of containers in datastage?

703


Why fact table is in normal form?

666


Give an idea of system variables.

585


Describe the main features of datastage?

651


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2025


What is difference between server jobs & parallel jobs?

621