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
- 12386 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
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
What is deployment group?
Can we create a Integration service without a Repository service and vice versa?
Can we get 1st record through Informatica(without sequence number).
What is a grid in Informatica?
Describe expression transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can we use mapping variables in informatica? Where do we use them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Why sorter is an active transformation?
Difference between Target-based loading and constraint-based loading?
What is the procedure for creating independent data marts from informatica 7.1?
What is option by which we can run all the sessions in a batch simultaneously?
What are the features of complex mapping?
What is meant by lookup transformation?
What all are steps in up gradation of Informatica server?
