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.

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

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

what is the difference between repository & Intergration service

1 Answers  

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---