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
- 4238 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
how to connect to a flatfile through ftp in informatica
What are the various tools used in etl?
what is the meaning of upgradation of Repository?
What is abap? What are idocs?
how would u estimate the size of Aggregator transform data and index cache?
What is cube grouping?
What is a staging area? What is the purpose of a staging area?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Can there be sub steps of etl steps?
what is the use of server?
what make u disappointmnets in u r career
Can u access a repository created in previous version of Informatica?
What are the ETL Testing Operations?
What is the difference between round-robin partitioning and hash partitioning?
What is a lookup table in etl?
