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
- 12451 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 pmcmd command?
what is informatica metadata?
How to differentiate between the active and passive transformations?
What is meant by lookup transformation?
What do you mean by filter transformation?
What are the types of caches in lookup?
Explain the features of connected and unconnected lookup.
What is the status code in stored procedure transformation?
Name the different lookup cache(s)?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the different types of transformation available in informatica.
What is aggregator transformation in informatica?
have u done any performance tuning? how u ll do?
What is the scenario which compels informatica server to reject files?
