indatastage 8.1 surrgoate key generates seqences numbers
write but there is limite value i want to reset the seqence
after gettting some highest value like i want o/p like this
1 2 3 4 5 .............10000 1 2 3.........10000



indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to..

Answer / bhaskar bokkala

Use the Sequence Generator transformation and set the end
value is 10000 and also click the cycle property.

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More ETL Interview Questions

how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  


what are the data modeling tools you have used?(polaris)

0 Answers  


What are dimensions?

0 Answers  


Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,






What is data modeling and data mining?

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


what is dynamic insert?

0 Answers  


what is the meaning of upgradation of Repository?

0 Answers   IBM,


Explain the use lookup tables and Aggregate tables?

0 Answers  


What is the difference between project backlog and product backlog?

0 Answers   IBM,


Categories