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 / 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 |
Give the benefits of data integration suite?
Define slowly changing dimensions (SCD)?
What is data cleaning?
Compare etl & elt?
what are the data modeling tools you have used?(polaris)
What is cube grouping?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
how do use session mapping parameters ?(in which transformation)
What is the difference between project backlog and product backlog?
What are the steps involved in etl process?
What do you understand by active and passive transformations?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?