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

What is IQD file?

1 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,

What are the transformations that are not supported in mapplet?

0 Answers  

Explain reference cursor?

1 Answers  

Can you copy the batches?

3 Answers  

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

what is lookupoverriding?

1 Answers  

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

How can we use batches?

0 Answers  

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

What do you mean by filter transformation?

0 Answers