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


Please Help Members By Posting Answers For Below Questions

What is DR strategy for Informatica project?

909


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1830


Explain the types of lookup transformation?

788


How we can create indexes after completing the load process?

931


Explain about Informatica server process that how it works relates to mapping variables?

830


How do you promote a non-reusable transformation to reusable transformation?

918


Is there any target staging area in informatica not staging area

2356


Explain why we use partitioning the session in informatica?

811


Make a note of the quantity vaults made in informatica?

779


Have you worked with/created Parameter file

1418


If informatica has its scheduler why using third party scheduler?

1015


What is the sql query overwrite in source qualifier in informatica

840


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1768


Under which circumstances, informatica server creates reject files?

836


tell me the rules and responsblites in our project(my project is development)

1714