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
How to improve the performance of a session using sorter transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain sessions?
Describe data concatenation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a snowflake schema?
can u any challenge your project?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are roles and groups and benefits of using them?
what is $$$$?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Do you find any difficulty while working with flat files as source and target?
What all are steps in up gradation of Informatica server?
list out all the transformations which use cache?
How many numbers of sessions can one group in batches?