Interested to Buy Any Domain ? << Click Here >> for more details...
how can u generate sequence of values in which target has
more than 2billion of records.(but with sequence generator
u can generate upto 2 biliion only)
- 6 Answers
- 20923 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
generate a sequance values through sequesnce generator and
connet it to the target get the max value of it every time
from unconnected lookup and set this value(maxvalue) to
mapping variable so that the last max value will be stored
in repository. Once the sequance generator is reached its
max value say 2billion , set the property reset to 1 so
that sequence generator will start again to produce
sequance numbers .
and in experession write the logic like
new_seq=max(mapping_variable+sequence_generator (value)
then it is like 2million+1...2......(seq_gen)
every time sequance generator will reset to 1 after
reaching its max value
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Informatica Checkpoints
What are the types of data warehouses?
What is the Process to creating lookup transformation in informatica
Explain direct and indirect flat file loading (source file type) - informatica
Explain the difference between a data warehouse and a data mart?
Can we create two repositories on same database instance in oracle?
permutations of mapplet
Explain the different kinds of facts.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is an active transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is the function of union transformation?
How do you promote a non-reusable transformation to reusable transformation?
How to configure mapping in informatica?
What is informatica worklet?
