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



indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to..

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

Post New Answer

More ETL Interview Questions

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  


where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  


How to know informatica conslole password??

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,






Explain about the data integration suite features?

0 Answers  


Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

1 Answers   IBM, Saama Tech, Wipro,


How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

0 Answers  


how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  


Explain etl?

0 Answers  


what is session partitioning?

0 Answers  


how do u implement unconn.stored proc. in a mapping?

1 Answers  


Categories