top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: How to generate sequence numbers using expression transformation?

+1 vote
2,667 views
Informatica: How to generate sequence numbers using expression transformation?
posted Mar 14, 2016 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In the expression transformation, create a variable port and increment it by 1. Then assign the variable port to an output port. In the expression transformation, the ports are:

 V_count=V_count+1

 O_count=V_count
answer Mar 15, 2016 by Manikandan J
Similar Questions
+1 vote

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

how can i get this same data with '$' symbol in target by using expression transformation in informatica?

anyone help me please, thanks in advance.

+2 votes

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

How can i get this same data with '$' symbol in target by using expression transformation in informatica?

+1 vote

I have a Column (SALARY) in Source Table from Relational DB, for example 15000 is a record in SALARY column and I want to format it as $15,000.00 into the Target table which is a Relational DB using Expression Transformation.

Thankyou

+1 vote

I have an xml file my tag is like

<'mytag'>'data'<'/mytag'>

I need to find position of <'/mytag'> using Informatica Expression transformation. How can I achieve that?

...