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

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

What are the new features of Power Center 5.0?

0 Answers  

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

What is union transformation in informatica?

0 Answers  

can we see default group,when we use router?if yes how?

2 Answers   L&T,

Define mapplet?

0 Answers  

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

can we override a native sql query within informatica? Where do we do it?

0 Answers  

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers