Interested to Buy Any Domain ? << Click Here >> for more details...
In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data
- 2 Answers
- 12314 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / santosh kumar sarangi
If sequence generator reached the maximum limit and can't
increase then do as follows.
1. Reset sequence generator to 0
2. Add a expression transformation make an out put port
Out_put_port= max_val_previous_sequence_gen+new_current_val
In this case you can generate next max value.
Let me know if any things wrong.
Thanks $ Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 4 Yes | 0 No |
what is the drillup & drill down?and use of the drill up and drill down?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
How do you change a non-reusable transformation to reusable transformation?
what is the Default Source Option For Update Strategy Transformation?
What is limitations of truncate and load option
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is the benefit of partitioning a session?
what is the necessity to use update strategy?(except for updates)
Which gives the more performance when compare to fixed width and delimited file ? and why?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
How many ways are there to do 'remove duplicate records in informatica'?
Teradata 
