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
- 4259 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 about etl data integration software?
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.
list and discuss two approaches for updation of target table in Informatica and how they are different.
how would u estimate the size of Aggregator transform data and index cache?
How can we use external procedural logic in informatica?
where is the cache (lookup, index) created and how can you see it.
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?
How many types of transformations supported by sorted input?
What is the difference between project backlog and product backlog?
Explain and compare etl & manual development?
What are cubes and olap cubes?
What is virtual Data Warehousing?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how to load the data to fact table?
how do u set partition points in the mapping?
