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
Answer Posted / 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 View All Answers
What is the difference between Data Warehousing and Data Mining?
what is granularity in Data ware House?
what is pmrep command?
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
tell me few points when u become TL
what is the use of server?
how would u estimate the size of Aggregator transform data and index cache?
Explain different types of partitioning?
What are various etl tools in the market?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
what is the difference steps for data modeling?
What is a mapping, session, worklet, workflow, mapplet?
what is the difference between cardinality and Nullability?
Explain the use lookup tables and Aggregate tables?
flat filevalidation in informatica