hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???

Answer Posted / jz

If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pmcmd command usage in informatica

708


How do you take back up of repository?

723


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1016


where to store informatica rejected data?

680


What is the commit type if you have a transaction control transformation in the mapping?

654






Write the advantages of partitioning a session?

745


Where can we find the throughput option in informatica?

600


How to create or import flat file definition in to the warehouse designer?

618


Make a note of the quantity vaults made in informatica?

560


What is meant by lookup transformation?

614


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

638


What is the format of informatica objects in a repository?

603


In informatica workflow manager, how many repositories can be created?

782


What is target load order?

806


Clarify the utilization of aggregator cache record?

578