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
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 |
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
where we cannot use sorter Transformation. if we use then we will not get correct data?
How to know informatica conslole password??
Identifying the bottlenecks in various components of Informatica and resolving them.
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?
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?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Explain etl?
what is session partitioning?
how do u implement unconn.stored proc. in a mapping?