Answer / krishna

Use database Sequence generator call this from stored
procedure or dummy lookup query

or

You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)

Answer / vijay

You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.

Answer / manikandan

I think your Express increment is not clear because when the second record will comes again it that variable is initialize to zero.

So we do to capture into Variable by SetVariable()

Or

The Use target lookup and return the column(SNo) which you what to populate the seq number.

Check in Express(before Target), If(isNull(SNo), 1, SNo+1). Connect this to SNo in Target

Answer / chaitanya

Use database Sequence generator

Answer / ganesh

You can handed this issue, using expression transformation.

1) create one variable port and declare it as Integer and
assign the value to Output port.

e.g: var_count Integer var_count+1
out_count Integer var_count

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

Why do we need informatica?

0 Answers  

---

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

What could be the possible resons of locks by user?

0 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---