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...

  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

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

What are the different kinds of views available in a datastage director?

0 Answers  

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

WHAT are unix quentios in datastage

2 Answers   TCS,

What is the use of datastage designer?

0 Answers  

How many Nodes configuration file you used in your last project?

1 Answers  

why we use hash file for lookup?

5 Answers  

For more Data Stage Interview Questions Click Here
Categories