In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data
- 2 Answers
- 10859 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 |
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What is repository manager?
What is the difference between informatics 7x and 8x and what is latest version?
Can we use parameters of parameter file in presession command
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
What is a filter transformation and why it is an active one?
Slowly changing dimensions, types and where will you use them
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
If we are using an aggregator but forget to mention the group by port .what will be the output??
Differentiate between reusable transformation and mapplet.
Teradata 
