Informatica : OracleSequenceGenerator

How to use Oracle Sequence in Informatica mapping instead of using Informatica Sequence Generator Tranformation.

[mokarem]

Thanks for your efforts. I am learning informatica from your videos. One benifit of using oracle sequence generator could be as it is inserted as primary key, in target table records can be inserted from other application like sql developer using the same sequence generator to maintain the uniqueness. No risk of duplicate key value. 

[sreyasmelodies]

Hi Mandar, I tried doing this but I get wierd error of 'inconsistent datatypes: expected DATE got NUMBER' when I add this SQL transformation. When I directly map SQ to Target without this sequence, the same Source Qualifier query works and it goes to Success. Only when I introduce this SQL transformation which I have all the input ports from SQ and added output port for the DB Sequence, I get this error.

[paniuday]

Thank you.. but what will the sequence count when we have a logic to do insert else update, will the sequence increase to same set of records pass through SQL transformation and update the target?

[saketsharma]

here we can use one more source qualifier for sequence generator why to have SQL transformation?