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

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

What is decode in informatica?

0 Answers  

How do you update the records with or without using update strategy?

0 Answers  

What are the different threads in DTM process?

2 Answers  

What do you mean by filter transformation?

0 Answers  

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

Can we create multiple integration service on single repository?

0 Answers