How to import oracle sequence into Informatica.

Showing Answers 1 - 2 of 2 Answers

sunil kumar

  • Feb 15th, 2006
 

CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.if still is there any problem please contact me.Thanks Good Luck!

deepika

  • Nov 7th, 2006
 

Hi sunil,

I got a problem with this...Can you jsut tell me a procedure to generate sequence number in SQl  like...

if i give n no of emplyees it should generate seq.and i want to use them in informatica...using stored procedure and load them into target..

can u help me with this..

thanks

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions