Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SEQUENCT GENERATOR TRANSFORMATION ERROR

Status
Not open for further replies.
venku72

venku72

Technical User
Sep 28, 2005
25
0
0
JP
Hi ,

I have a situation that i need to generate different sequences based on a condition.I created all the sequences and specified the requeored ranges and created a transformation and in that i have a condition like

If FIELDA='A' then nextval
else if field=''b' then nextval1 etc...

when i run the mapping i am getting an error saying Sequance generatior transoformation:Overflow error..

What is this error and how to resolve this?

How many sequences can i create in a mapping?Is there any limit for this? Btw I am using Informatica 8.0

Pls help...
 
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Filter transformation - filter condition
Replies
1
Views
45
rasETL
rasETL
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
55
sa0309
sa0309
sa0309
  • Locked
  • Question
Flat File Transformation
Replies
0
Views
27
sa0309
sa0309
newbie1314
  • Locked
  • Question
New to informatica, need help with expression transformations
Replies
0
Views
40
newbie1314
newbie1314
shubhangi77
  • Locked
  • Question
dense ranking in rank transformation in informatica
Replies
0
Views
30
shubhangi77
shubhangi77

Part and Inventory Search

Sponsor

Back
Top