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
- 20424 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
How to load last n records of file into target table - informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Can anyone tell me the new features in Informatica 9 Version?
how to create user defined function (udf) in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Is there any target staging area in informatica not staging area
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is decode in static cache?
What is the fact table?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is the size of your data warehousing?
What is standalone command task?
How can we improve session performance in aggregator transformation?
Differentiate between joiner and lookup transformation?
