indatastage 8.1 surrgoate key generates seqences numbers write but there is li

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

Question Posted / ravi

1 Answers
5194 Views
TCS, I also Faced
E-Mail Answers

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

What is the difference between project backlog and product backlog?

0 Answers IBM,

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers

what is the difference between OLTP database and data warehousing database?

3 Answers

what is Forward,Reverse and Re_engineering?

0 Answers QualTech,

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers SS Solutions,

Explain etl?

0 Answers

Explain about round-robi?

0 Answers

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.