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

Write the prerequisite tasks to achieve the session partition?

867


What is the use of source qualifier?

905


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1691


Target increases every day even though no new record was inserted

1368


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1881


What is the sql query overwrite in source qualifier in informatica

861


What are the reusable transformations?

919


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6683


write a query to retrieve the latest records from the table sorted by version(scd)

870


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

920


How many dimensions are there in informatica?

856


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

1849


What are session parameters ? How do you set them?

1606


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1947


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1706