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

how to we create datamart?

2 Answers   HSBC,

---

Write the different tools in the workflow manager?

0 Answers  

---

What is status code?

2 Answers  

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

Is stop and abort are same in informatica?

0 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

What is data merging,data cleansing,sampling?

4 Answers  

---