1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / revanth

Answers were Sorted based on User's Feedback



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

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 :)

Is This Answer Correct ?    4 Yes 1 No

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

Answer / revanth

Use the row number column in options of sequential file.

Is This Answer Correct ?    3 Yes 1 No

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

Answer / suneel

Hi Ankit,

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

Thanks

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Data Stage Interview Questions

How do you import and export data into datastage?

0 Answers  

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,




im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 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,

how to call routines in stages?

3 Answers   ME,

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

For more Data Stage Interview Questions Click Here
Categories