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

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

How does the aggregator transformation handle null values?

0 Answers  

---

How many cubes create from a single model?

1 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---