how do u use sequence created in oracle in informatica?
Explain with an simple example

Answer Posted / vijay

By using the Stored Procedure

please corect me if am wrong

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660


What are the different options available for update strategy?

580


What are Dimensional table?

619


What are the different types of transformation available in informatica.

639


How might you approve all mappings in the archive all the while?

602






How to generate sequence numbers without using the sequence generator transformation?

649


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679


What are multi-group transformations?

566


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

697


How do you take back up of repository?

723


What is expression transformation?

637


What is union transformation?

575


Explain the difference between a data warehouse and a data mart?

600


How can we remove the duplicates from flat file source?

583


What are the components of Informatica? And what is the purpose of each?

624