Using DB Sequence in Informatica mapping

Get new comments by email
You can cancel email alerts at anytime.
Comments (4)

Chetty in Westport, Connecticut

88 months ago

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

Regards,
Chetty

- Was this comment helpful? Yes (2) / No (1) Reply - Report abuse

Moin in Cleveland, Ohio

80 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

- Was this comment helpful? Yes / No Reply - Report abuse

Rajeshkumar in Stamford, Connecticut

77 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....

- Was this comment helpful? Yes / No Reply - Report abuse

naga in Framingham, Massachusetts

76 months ago

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

inform me if i wrong

- Was this comment helpful? Yes (1) / No Reply - Report abuse

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