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
- 12458 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 are the different tools in workflow manager?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
How to improve the performance of Aggregate transformation?
what is degenerated dimension?
Performance wise which is better joiner or look up ? Give me with example?
How will you display "Mr" for male & "Mrs" for female in target table?
why u go for dimensions ?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How can a transformation be made reusable?
What are multi-group transformations?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
 Informatica Checkpoints
Teradata 
