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
What is the use of source qualifier?
Explain in detail scd type 2 through mapping.
how tokens will generate?
What do you understand by SOA of Informatica?
What is the function of union transformation?
Differences between connected and unconnected lookup?
Explain why we use partitioning the session in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the mapping parameters and mapping variables?
Explain in detail about scd type 1 through mapping.
What does update strategy mean, and what are the different option of it?
What is meant by LDAP users?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How do you load only null records into target? Explain through mapping flow.
The question was on time stamp. what is the difference between HH and HH24 when to use when.