In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data

Answer Posted / shilpa

When a Seq Gen Transformation reaches its maximum value and
the sequence is not configured to cycle, the session fails.

Either you need to cycle the sequence or increase the end
value.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

760


Can we create multiple integration service on single repository?

916


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1902


What is an Integration service in Informatica?

879


How do you remove duplicate records in informatica? And how many ways are there to do it?

883






Differentiate between source qualifier and filter transformation?

1263


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5322


What does refresh system mean, and what are its distinctive choice?

756


How to join three sources using joiner? Explain though mapping flow.

872


Explain transaction control transformation in informatica

1004


What is main use of mapplet?

851


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

968


Why union transformation is an active transformation?

838


What are the different clients of powercenter?

787


Partition, what happens if the specified key range is shorter and longer

2204