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
- 4246 Views
- TCS, I also Faced
- E-Mail Answers
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
explain the methodology of Data Warehousing?(Polaries)
what is the difference steps for data modeling?
what is the difference steps for data modeling?
Difference between flat files and relational sources?
what are the facilities provided by data warehouse to analytical users?
SCD2 will work on only dimension tables as well as fact Table?
where is the cache (lookup, index) created and how can you see it.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain and compare etl & manual development?
When do we analyze the tables?
How etl testing is different from database testing?
what are the types in error loging?
How to increase performance without changing anything in mapping.( In prod)
What are your responsibilities as an etl tester?
