Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5258 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
what is dynamic insert?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is etl process?
Explain and compare etl & manual development?
what are the types in error loging?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are the different etl testing categories as per their function?
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?
What is a lookup table in etl?
What do you understand by active and passive transformations?
Explain do we need an etl tool? When do we go for the tools in the market?
how do u set partition points in the mapping?
Explain about hash partitioning?
