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
- 12450 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 |
How many cubes create from a single model?
When do you use mapping parameters? (In which transformations)
What is the default source option for update stratgey transformation?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
how can u tune u r informatica mapppings
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the main issues while working with flat files as source and as targets ?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the difference between informatica 7.0 and 8.0?
What is surrogate key?
Global and Local shortcuts. Advantages.
Teradata 
