Answer / sree

CURR_VAL is NEXT_VAL plus incermentby value.

Answer / ramesh

The current value is used when we enable the recycle option in sequence generator. The current value is the starting value for the next cycle.
Ex: if we enable cycle and current value as 3 and end value as 20, then the next cycle starts from 3 after 20.

Let me know if i am wrong on ramesh.kom@hotmail.com

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

What is the Hierarchy of DWH?

1 Answers  

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

how to obtain performance data for individual transformations.

2 Answers  

---

connected and unconnected lookups?

4 Answers  

---