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 |
what is the difference between OLTP database and data warehousing database?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what is the difference between OLTP database and data warehousing database?
When do we analyze the tables? How do we do it?
When do we go for the tools in the market?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
What is tracing level and what are the types?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
How many steps etl contains explain with example?
What are three tier systems in etl?
What is grain of fact?
What is partitioning? Explain different types of partitioning?