How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).


Answer Posted / 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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In how many ways we can create ports?

701


How can you generate reports in informatica?

581


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1533


Define mapplet?

627


list out all the transformations which use cache?

689






What is meant by LDAP users?

695


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1869


What is substr in informatica?

662


What do you understand by a term domain?

670


How to partition the Session?

648


To import the flat file definition into the designer where should the flat file be placed?

677


What are active transformations.

1188


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1320


Define enterprise data warehousing?

636


What is event and what are the tasks related to it?

616