Using DB Sequence in Informatica mapping

Comments (4)

Chetty in Westport, Connecticut

93 months ago

How can I get Sequence number from a db sequence in informatica mapping?

Regards,
Chetty

Moin in Cleveland, Ohio

85 months ago

Chetty in Westport, Connecticut said: How can I get Sequence number from a db sequence in informatica mapping?

Regards,
Chetty

Hi Chetty,

Use sequence generator transformation before target to get unique warehouse keys.

Thanks

Rajeshkumar in Stamford, Connecticut

82 months ago

Cheety you are wrong...question is how to get sequence number from DB not from informatica....

You have to use stored procedure ( used for creating sequence in oracle ) and call it into the informatica stored procedure trx to get sequence number from DB.

Update me ,if i m wrong....

naga in Framingham, Massachusetts

81 months ago

we can write sql override using db squence in source qualifier transformation

inform me if i wrong

» Sign in or create an account to comment on this topic.