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
- 1 Answers
- 4226 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What are materialized views & where do we use them?
What is tracing level and what are the types?
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
what is an ETL or ETT? And what are the different types?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
what is the use of structures?how many nodes can u create in a structure?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what make u disappointmnets in u r career
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
What are the steps involved in etl process?
what is a worklet?
Teradata 
