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

Answer Posted / vijay

Using Stored Porcedure Transformation we can call the
Sequence Generator

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we handle two sessions in informatica?

602


How do we call shell scripts from informatica?

581


What is lookup change?

610


Explain the pipeline partition with real time example?

637


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

617






server hot-ws270 is connect to Repository B. What does it mean?

1843


How to go to the older version for a mapping?

586


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2307


How big was your fact table

1302


What are some examples of informatica etl programs?

521


How you prepared reports for OLAP?

1136


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

543


What is the meaning of up gradation of repository?

1374


How do you use reject loader.

2052


What are the new features of informatica 9.x developer?

522