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
- 20698 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
What are the new features of informatica 9.x in developer level?
What is mapping debugger?
What are the types of presistent cache in look up tr.
How to update a particular record in target with out running whole workflow?
What is the reusable transformation?
how to load dimension table and fact table. plz tell me the steps.
What are the components of Informatica? And what is the purpose of each?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
During the running session, output files are created by informatica server. Enlist few of them.
Why filter transformation is an active one?
tell me the rules and responsblites in our project(my project is development)
hi real timers . iam waiting for ur reply regarding ETL TESTING
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is main use of mapplet?
