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
- 12432 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shilpa
When a Seq Gen Transformation reaches its maximum value and
the sequence is not configured to cycle, the session fails.
Either you need to cycle the sequence or increase the end
value.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / 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 |
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
What are the prerequisite tasks to achieve the session partition?
how to load rows into fact table in data warehouse
how to get max value record into one target and remaining records into another target?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is a command that used to run a batch?
Enlist the advantages of informatica.
What is the need of etl tools?
How/where can i install Informatica software with oracle or teradata as database
what is the purpose of surrogate key and diff between primary key&surrogate key
can we override a native sql query within informatica? Where do we do it? How do we do it?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
Teradata 
