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)
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
State the differences between sql override and lookup override?
what is degenerated dimension?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What if the source is a flat-file?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is union transformation in informatica?
What is the use of transformation?
what is INFORMATICA TESTING process
What is data caches/ index caches?
How many dimensions are there in informatica?
What are the transformations that are not supported in mapplet?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain pmcmd command usage in informatica
What is domain and gateway node?
Explain the etl program with few examples.