In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data
Answer Posted / 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 |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Define mapping and session?
What is workflow manager?
Implementation methodology
scenario where i can use only concurrent execution of workflow.
Name the different lookup cache(s)?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How we can use union transformation?
How can one identify whether mapping is correct or not without connecting session?
What is the scenario which compels informatica server to reject files?
What are the main issues while working with flat files as source and as targets ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Different circumstance which drives informatica server to expel records?
What is the need of etl tools?