top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Informatica : Sequence generate

+2 votes

Without using sequence generator How can we generate sequences in informatica mapping ?


posted Oct 6, 2014 by Amit Sharma

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

1 Answer

0 votes

1.If you have a relatively simplistic mapping, you can embed a oracle/db sequence.nextval call hidden in the source qualifier. can embed db/sequence call in a sql tranformation too. But know that it would be anti-performant. will be able to achieve a sequence generator behaviour using a persistent variable too, but there are limitations and downsides.

Depending upon what you are trying to do and where you are getting stuck, you might want to repost/edit our question.. and perhaps get a more direct answer.

answer Oct 7, 2014 by Shweta Singh
Similar Questions
0 votes

Currently datasets are getting generated in MF if there are 1 or more than 1 records coming from source. If there are no records from source, then empty data set is not created in MF.

As a solution, we tried to give pre-sql in session specifying all basic properties. But still our session failed with the below error:

Message Code: PWXPC_12015 Message: [ERROR] Error message: 
[[Informatica][SCLI PWX Driver] PWX-00265 DBAPI Error. DB_EXECSQL failed for file . 
[Informatica][SCLI PWX Driver] PWX-01275 DBNTC ExecSQL failed for file , rcs 260/265/0.]
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.