Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,


what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,


How we can covert server job to a parallel job?

0 Answers  


How to initialize environment variables?

4 Answers   Infosys,


my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,


How did you reconcile source with target?

3 Answers   HP,


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


Notification Activity

0 Answers   CTS,


What are the different layers in the information server architecture?

0 Answers  


can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,


What are the functionalities of link collector?

0 Answers  


i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,


Categories